Forum Discussion

BSchrave's avatar
BSchrave
New Member
6 years ago
Solved

matrix with percentages

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 zorgaanbiederAantal factuurregelsAantal te laat ingediende factuurregelsAantal te laat ingediende factuurregels gedeeld door Aantal factuuregels           
A343237%          
B3414814%          
C273135%          
D1032120%          
              
              
              
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])

 

 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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

     

     

4 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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's avatar
      BSchrave
      New Member
      6 years ago

       

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

       

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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