Forum Discussion

vijayvizzu's avatar
vijayvizzu
Helper III
6 years ago
Solved

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 ...
Need Help
Show and Tell
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    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

vijayvizzu's avatar
vijayvizzu
Helper III
6 years ago

amitchandak I have modified existing formula with your formula, but seems doesn't work. It gives me same values as [Total USD] measure.

 
amitchandak's avatar
amitchandak
Super User
6 years ago

You want to a sum till moth level and then do Avg. If yes, We need make sure data grouped at month level and avg took after that.

So the change would, you replace [Total USD] with what ever formaul you want

AverageX(summarize(CALENDAR,CALENDAR[MonthYr],"_sum",[Total USD]),[_sum])

 

If it did not work

Can you share sample data and sample output.