Forum Discussion
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 when I choose just a month , for example july, it calculates only the july value. here is the measure:
Date max = MONTH(MAX('Base Act W&D _ SAP'[Date]))
YTDPlan = CALCULATE(SUM('Base Act W&D _ SAP'[Plano 2020.Value]);ALLCROSSFILTERED('Base Act W&D _ SAP');FILTER('Base Act W&D _ SAP';2020>=YEAR('Base Act W&D _ SAP'[Date]));FILTER('Base Act W&D _ SAP';[Data max Filtro]>=MONTH('Base Act W&D _ SAP'[Date])))
Those are not real numbers. just for test.
Those are not real numbers. just for test.
4 Replies
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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.
