Row Total/Column Totals

[Anonymous]

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 )

[v-yiruan-msft]

Hi @Anonymous ,

You can refer the solution in the following links to resolve it:

Matrix Totals error

Why Your Total Is Incorrect In Power BI

Wrong Grand Totals in Power BI

Dax for Power BI: Fixing Incorrect Measure Totals

Best Regards

[Greg_Deckler]

@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/547907

[Anonymous]

@Greg_Deckler  i typed tableau by mistake 😋
Need this for power BI only , will go through you refrences .and will ping you