I need to do 2 average measures. The normal one and the cumulative measure, both in dax.
My TimeSheet table has time value in hours (1,2) and unit value according some factors, and another with Total Value (Value).
What i would like to have is the average of Value (which is , for each client, employee,project, for a particular period, chosen on the filter box. Basically i need to know the average for each column in yellow (attach file) This measures i’m gonna show them in a graphic visual with month and year as x values.
Now, as for my “regular” averagex, i thought it could be something like this:
Average Value = AVERAGEX( ‘Tab TimeSheet’, ‘Tab TimeSheet’[Value])
My table is the other fact table so, for me to have the total of value, for example :
TS Value = CALCULATE(SUM( ‘Tab TimeSheet’[Value] ),
USERELATIONSHIP( ‘Tab Dates’[Date], ‘Tab TimeSheet’[TS Date] ))
Can any of you help me to do these 2 measures (normal and cumulative)? Maybe i will understand once and for all the concept with and without context and when to use ALL, or ALLSELECTED, and so on
Thank you all and i’m sorry to boder you again
PedroAverageX.xlsx (34.2 KB)