Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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)
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 33 | |
| 33 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 67 | |
| 67 | |
| 45 | |
| 30 | |
| 26 |