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 I'm new. Can somebody help me to get the right percentage for each row in my matrix.
I have a matrix with numbers in two different columns.
Both numbers are calculated wit quick measures.
I would like to add another column with percentages for each row.
I made a new quick measure but the results are not de percentages I like to show.
In the example the percentages in the third column I would like as result.
In the matrix I can only choose for percentages calculated from total, total column and total row.
But that's not what I want.
I added the formulas that I've used.
My English is not so good.
And the example is in Dutch, so I hope somebody in this community is Dutch and can help me.
Naam zorgaanbieder | Aantal factuurregels | Aantal te laat ingediende factuurregels | Aantal te laat ingediende factuurregels gedeeld door Aantal factuuregels | ||||||||||
A | 343 | 23 | 7% | ||||||||||
B | 341 | 48 | 14% | ||||||||||
C | 273 | 13 | 5% | ||||||||||
D | 103 | 21 | 20% | ||||||||||
Aantal factuuregels = DISTINCTCOUNTNOBLANK('Datadump Declaraties met Crediteringen'[Declaratieregel Id]) | |||||||||||||
Aantal te laat ingediende factuurregels = DISTINCTCOUNTNOBLANK('Datadump Declaraties met Crediteringen'[Aangepast declaratieID]) | |||||||||||||
Aantal te laat ingediende factuurregels gedeeld door Aantal factuuregels = DIVIDE([Aantal te laat ingediende factuurregels], [Aantal factuuregels]) |
Solved! Go to Solution.
Hi, @BSchrave
Can you share some sample data about your table “'Datadump Declaraties met Crediteringen'”.
I test your measure in my sample data.Everything works well.
Please check if there is any filters applied in the visual.
Best Regards,
Community Support Team _ Eason
Hi, @BSchrave
Can you share some sample data about your table “'Datadump Declaraties met Crediteringen'”.
I test your measure in my sample data.Everything works well.
Please check if there is any filters applied in the visual.
Best Regards,
Community Support Team _ Eason
Thank you so much. Sometime the solution is so simple. I overlooked the adjustment complety.
@BSchrave - Chapter 4, Recipe 7: https://github.com/gdeckler/DAXCookbook
@BSchrave , I think because of distinct count GT can change.
try like
sumx(values(Table[Naam zorgaanbieder]) ,[Aantal te laat ingediende factuurregels gedeeld door Aantal factuuregels])
or
AverageX(values(Table[Naam zorgaanbieder]) ,[Aantal te laat ingediende factuurregels gedeeld door Aantal factuuregels])
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |