card for matrix visual show value as percentage of row tatal

[anglefbi11]

hi guys

i am facing a difficulty with adding card for a matrix visual

i created a matrix and having two values.  

*  first value called alert and the count of this data is already there in my excel file

*  the second value called ( % ) and this data is not there in my excel file. i created this by using matrix visual and the value is based on the percentage of row total

my question is

i already added a card visaul for the first value which is ( alert ) and this one works fine

i need a small help so i can add another card visual which will display the % for each user 

kindly see the below picture

kindly notice the below is my data which i used for matrix

i used alert ID two times 

one time i insterted it with no calculation

the second time i inserted it and i changed the value to be ( percentage of row total ) which i rename it to % 

how do i show the percente of row total into card visual ?? 

sorry for the long question ...

this is my pbix file

https://drive.google.com/file/d/1saqhRLnMNMZ3g54-8lIRYHAajj32O237/view?usp=drive_link

@Anonymous

thank you brother for assesting me yesterday . but my issue is still there because i didnt explain what i need correctly

[Ritaf1983 · Accepted solution]

Hi @anglefbi11 there is no access to your pbix in the attached link so I created my little example.

To get the desired results you can create 2 measures :
1. For the alerts count :

alerts (#) = COUNTROWS('Table')

2. For the percentage :

alerts (%) = DIVIDE([alerts (#)],CALCULATE([alerts (#)],ALL('Table'[Minutes])))

You can use both of them at the card and matrix 

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[anglefbi11]

thanks brother it works fine but there is a small thing.  if i select one row for user C and i choose another row for user F i does not calculte.  i mean the calculation is working only for Horizontal .  but when you choose some different vertical values it does not work. is there any solution ?

[Ritaf1983]

Hi @anglefbi11 
If you select the entire row the results always will be 100% because the percentage is on the row level.
The formula calculates which percentage of every category is from the user's alerts.

If you select specific categories of specific customers than you will get the results of selected customers and selected categories:

Users: c,d, and v have 16 alerts in total.
I selected 7 
Their percentage from 16 is 44% 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[anglefbi11]

thank you brother i got it