Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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 )
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
@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
@Greg_Deckler i typed tableau by mistake 😋
Need this for power BI only , will go through you refrences .and will ping you
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |