cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Soof1234
Helper I
Helper I

Totals not correct in table

Hi,

 

To start with, excuse me for creating a topic which already discussed several times, but I am quite lost why the totals are not showing correctly. Used to achieve this before but havent worked with power BI in 2 years, somehow I cant get it done whatever I do. I created a simple overview with little data to replicate my issue. 

 

Table 1:

Soof1234_0-1669198504063.png

 

Table2: 

Soof1234_1-1669198544905.png

 

My table output:

Soof1234_2-1669198668441.png

 

As you can see my totals are not correct.

Measure I used for counting totals costs per service:
 
Total cost per service = CALCULATE(SUM('Prices'[Price per month]) * COUNT('Users'[Product]))
Exchange online is not used by any user, but probably sums up as well
 
Please help as I am wasting way to much time on this now...
 
Kind Regards,
 
Soof1234

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@Soof1234 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
daXtreme
Super User
Super User

How is it possible that you don't indicate the subscription type for Table2? How is the model to know what subscription type a user has subscribed to? It looks like certain info is missing from the model...

Jihwan_Kim
Super User
Super User

Hi,

I am not sure how your datamodel looks like, but please check the below picture and the attached pbix file.

I tried to create a sample datamodel like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.

All measures are in the attached pbix file.

 

 

Jihwan_Kim_1-1669199850104.png

 

 

Jihwan_Kim_0-1669199833033.png

 

 

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Greg_Deckler
Super User
Super User

@Soof1234 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

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

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors