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

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
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