topic Re: Row Total/Column Totals in Developer

Row Total/Column Totals

Anonymous — Wed, 30 Dec 2020 17:44:59 GMT

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 )

Re: Row Total/Column Totals

Greg_Deckler — Wed, 30 Dec 2020 17:42:05 GMT

@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

Re: Row Total/Column Totals

Anonymous — Wed, 30 Dec 2020 17:46:52 GMT

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

Re: Row Total/Column Totals

Anonymous — Mon, 04 Jan 2021 06:52:29 GMT

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