Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Acumulated function ignoring slicer

I´m having dificult with a measure , I have a Slicer that filters months , another that filters year, but I want a measure to calculate the sum of the year to that month selected. the problem is that...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi Anonymous 

 

Try below measure:

YTDPlan = var a = IF(HASONEVALUE('Base Act W&D _ SAP'[Year]),SELECTEDVALUE('Base Act W&D _ SAP'[Year]),BLANK())
Return 
CALCULATE(SUM('Base Act W&D _ SAP'[Plano 2020.Value]),FILTER(ALL('Base Act W&D _ SAP'),[Data max Filtro]>=MONTH('Base Act W&D _ SAP'[Date])&&YEAR('Base Act W&D _ SAP'[Date])=a))

Pbix attached. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi, it still doenst work the value should be 13.718.798 for the july month , but this measure is giving the whole ammount of the year . I just need the accumulated until a month. But thank you for the help.