cancel
Showing results for
Did you mean:

## problem in logic of totals

Dear very good morning, I have a problem with the logic of GDP that takes to solve this matrix, if you look at the capacity T is the multiplication of counting deaths and sum of capacity, but for each row is ok but the sum of the rows in capacity T is incorrect since BI multiplies the total of counting functions by the total sum of capacities and divides it by 4

but what I need is for you to add each row down.

Anyone have any ideas?

thank you very much for the help

1 ACCEPTED SOLUTION
Super User

@Syndicate_Admin 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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
4 REPLIES 4
Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com

thanks for the help, but you already solved it with the link

Super User

@Syndicate_Admin 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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thank you very much with this I was able to do it

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors