Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@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.
@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
Still getting the same situation. The repeated rates are not getting added up. My categories comes from different tables, maybe that´s the issue
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
46 | |
28 | |
25 | |
18 | |
17 |