Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
andresgl06
Frequent Visitor

Calculate Totals for different ID but same price

Hi everyone,

 

I´m having the following problem; i need to create a matrix visualization where my first column are Clients and those clients have license plates associated to them (See image attached). So every license plate have a rate (How much we charge one client for that vehicle), and sometimes that rate is the same for different vehicles. Basically the problem is having the same price for different ID's.

In the attached image you can see that the total it´s not right, it´s not considering those repeated rates and gives me a total that´s a lot less than it should be.

Any suggestions for a DAX formula or measure? I´ve tried some stuff but don´t seem to work out. Thanks a lot in advance.Example.PNG

4 REPLIES 4
amitchandak
Super User
Super User

@andresgl06 , you have use values on summarize or values to force the row-level calculation to sum up

 

https://www.youtube.com/watch?v=Ka7Ds4EAjNQ

 

 

Thanks for your answer, i wound up watching this video;

https://www.youtube.com/watch?v=44QUjA5NDwY

 

After a few modifications the measure finally did what i was looking for.

Greg_Deckler
Super User
Super User

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


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

Still getting the same situation. The repeated rates are not getting added up. My categories comes from different tables, maybe that´s the issue

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors