Forum Discussion

phjz's avatar
phjz
Frequent Visitor
2 years ago

YTD gets calculated in wrong order

I had a YTD calculation which worked well so far:   YTD = CALCULATE(AVERAGEX(SUMMARIZE('Data','Data'[CW],"Weekly",[Old_Value_Measure]),[Weekly]),FILTER(all(Calendar),Calendar[Year] = MAX(Calendar[...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi phjz 

 

Please try the following DAX:

MEASURE =
CALCULATE (
    SUM ( 'Table'[New_value] ) / COUNTROWS ( 'Table' ),
    FILTER (
        ALL ( 'Calendar' ),
        'Calendar'[Date].[Year] = MAX ( 'Calendar'[Date].[Year] )
            && 'Calendar'[Date] <= MAX ( 'Calendar'[Date] )
    )
)

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

phjz's avatar
phjz
Frequent Visitor
2 years ago

Thanks for your reply, but that doesn't work for me, because New_Value is a measure: New_Value_Measure = Old_Value_Measure * Total_Universe / Entitled_Universe

So, I can't sum up this measure....

 

Any other ideas?
Thanks!