Forum Discussion
Discrepancy in Total Row using SUM
Hi!,
Many thanks for taking the time to review my model.
Data comes from different tables because one had the project baseline information and another was a kind of activities master.
Anyway, I will close this thread. I've modified a little bit my model: I've created an additional table with the original budget for every activity. Now, all the measures work fine.
Again, thank you a lot for your time.
Regards,
jcarlos 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
Greg_Deckler Many thanks for your quick reply.
Now, I understand the difference at Measure Totals.
However, if you look again the table, there are discrepancies even at row level.
Regards,
jcarlos Without knowing your data, I have no idea what you are expecting to see at the row level. What should the numbers be?
Greg_Deckler The second column (Plan_NLU_by_Category) should have the same figures as the first column. In the 5th column, all the figures should be 100%.
Knowing about the measure issues...the Totals are ok in every column.
Hi, jcarlos
I still don’t understand why Plan_NLU_by_Category should have the same figures as Plan_NLU?
I have checked that the calculated values of Plan_NLU and Plan_NLU_by_Category come from two different tables.
If just compare the result in the total row, I did not find any errors in your file.
Best Regards,
Community Support Team _ Eason
