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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

thank you brother i got it

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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