Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
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")))
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")))
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 6 | |
| 6 |