Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

Data Table 

 

 

Monthly_Toiletries_Forecast = IF([Toiletries Forecast]=0,0, CALCULATE([Toiletries Forecast],FILTER('Date',MONTH('Date'[Date])=MONTH(TODAY())),FILTER('Date',YEAR('Date'[Date]=YEAR(TODAY())))))

 

Expected results

 

Current Results 

 

 

 

  • lbendlin's avatar
    lbendlin
    6 years ago

    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")))

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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")))