Forum Discussion
Row Total/Column Totals
Hi All,
We are applying round sig fig on each data value and summing the total at row n column level . Now I am facing some discrepancies because Power Bi is calculating the raw data and applying the sig fig rule ,instead i want the sum should be done on the already converted sigfig Value.
PFB the SS , the figures doesnt add up .
How can i make Power Bi to sum the displayed figures and not the raw data (without any calculations being applied )
3 Replies
Anonymous - Not sure about Tableau. 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/547907Greg_Deckler i typed tableau by mistake 😋
Need this for power BI only , will go through you refrences .and will ping you
Hi Anonymous ,
You can refer the solution in the following links to resolve it:
Why Your Total Is Incorrect In Power BI
Wrong Grand Totals in Power BI
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards
