Forum Discussion
Average Cumulative not working
Hi Folks, I have been trying to fix the error, unable to resolve it. I had created a measure "Avg USD" which normally calculate average values for each month. Its working good, and now i had creaetd another measure "Cummulative Avg" to create a cumulative of average measure, which doesn't work.
Hence to check the calculation, i had created a measure "Total USD" to calculate the sum of values of a column, in this measure i just replaced the AVERAGEX function with SUMX, its working good too. Then i had created a measure "Cummulative" to generate the cummulative of Sum. This is working fine too.
I was wondering, why the same structure behaves differently with SUMX and AVERAGEX.
Please see the snapshot i have attached.
Could you please help,where i am doing wrong. I recently started working on this Power BI.
Problem pic
Hi,
Please try this measure:
Cummulative Avg = SUMX ( SUMMARIZE ( FILTER ( ALLSELECTED ( Calendar ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) ), 'Calendar'[MonthYr], "Avg", [Avg USD] ), [Avg] )Best Regards,
Giotto
7 Replies
Hi,
Please try this measure:
Cummulative Avg = SUMX ( SUMMARIZE ( FILTER ( ALLSELECTED ( Calendar ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) ), 'Calendar'[MonthYr], "Avg", [Avg USD] ), [Avg] )Best Regards,
Giotto
v-gizhi-msft amitchandak Thank you everyone for your support
vijayvizzu m Are you using Monthyr from Calendar table?
amitchandak : Yes, i am using custom calender table. Please see the relational model for your reference.
Try Avg USD like this
AverageX(summarize(CALENDAR,CALENDAR[MonthYr],"_sum",[Total USD]),[_sum])Seem like row context issue
