Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
anglefbi11
Helper I
Helper I

card for matrix visual show value as percentage of row tatal

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

 

 

anglefbi11_0-1716579005792.png

 

 

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

 

anglefbi11_2-1716579468183.png

 

 

 

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 % 

 

 

 

 

 

anglefbi11_3-1716579742072.png

 

 

 

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

 

 

 

@v-heq-msft

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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')
Ritaf1983_0-1716622059975.png

2. For the percentage :

alerts (%) = DIVIDE([alerts (#)],CALCULATE([alerts (#)],ALL('Table'[Minutes])))
Ritaf1983_1-1716622233241.png

You can use both of them at the card and matrix 

Ritaf1983_2-1716622287299.png

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.

View solution in original post

4 REPLIES 4
Ritaf1983
Super User
Super User

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')
Ritaf1983_0-1716622059975.png

2. For the percentage :

alerts (%) = DIVIDE([alerts (#)],CALCULATE([alerts (#)],ALL('Table'[Minutes])))
Ritaf1983_1-1716622233241.png

You can use both of them at the card and matrix 

Ritaf1983_2-1716622287299.png

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.

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 ?

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.

Ritaf1983_0-1716644367970.png

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

Ritaf1983_1-1716644505544.png

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.

 

thank you brother i got it

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.