matrix with percentages

[BSchrave]

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])

[v-easonf-msft · Accepted 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.

pbix attached

Best Regards,
Community Support Team _ Eason

[BSchrave]

Thank you so much. Sometime the solution is so simple. I overlooked the adjustment complety.

[Greg_Deckler]

@BSchrave - Chapter 4, Recipe 7: https://github.com/gdeckler/DAXCookbook

[amitchandak]

@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])