Forum Discussion
Measure return wrong results
I wrote the below measure to extract my current month forecast figures from a table. The measure returns correct figures for categories B,C,D and a completely different figure for category A alone. ...
show your measure definition for [Toiletries Forecast]
you can simplify the filter quite a bit too
Monthly_Toiletries_Forecast = IF([Toiletries Forecast]=0,0, CALCULATE([Toiletries Forecast],FORMAT('Date'[Date],"YYYYMM")=FORMAT(TODAY(),"YYYYMM")))
