Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I created a table with Year Quarter Month Matrix.
The problem is that, I have this Measure that is not summing up correctly. Here's the details:
I have two separate table (that is both connected to a general Calendar)
Table1 : I used this in getting the Forecast. (Created a SUM(Forecast) from here)
Table2 : I used this in getting the Sales. (Created a SUM(Sales) form here)
I have a measure that goes like:
Measure = IF(SELECTEDVALUE(Date) > TODAY(), Forecast + Sales, Sales
The issue is that It is only Summing up Total only by Sales. It is not including summing up the Forecast on the Total (Column Subtotal)
Is there something i'm missing or did wrong? Let me know. Would appreciate yall help.
More Details:
(Q4 is all forecast)
@EvanGetsItDone This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Hi i've applied and got tips from your links. However the same issue is still occuring. Values are showing up but not on the total end. It is quite weird why they are not summing up. @Greg_Deckler
Basically the screenshot above, the totals are only summing up the Sales, but not the forecast (the Q4 is all forecast no sales, thats why the total is blank on Q4, but it needs not to be blank)
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |