Calculate Totals for different ID but same price

[andresgl06]

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.

[amitchandak]

@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

[andresgl06]

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]

@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

[andresgl06]

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