Forum Discussion

anglefbi11's avatar
anglefbi11
Helper I
2 years ago
Solved

card for matrix visual

hi guys i am facing a difficulty with adding card for a matrix visual   i created a matrix and the two values one of them is count of alert second is total percentge of row total   when i adde...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi anglefbi11 ,
    You can change the measure to something like this:

    Total ppercentage of alert = 
VAR a = 
CALCULATE(
    SUM('Table'[Alert]),
    ALL('Table')
)
RETURN
SUM('Table'[Alert])/a

    Put in matrix and a card

     

    Best regards,
    Albert He

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

     

anglefbi11's avatar
anglefbi11
Helper I
2 years ago

hi

thank you for your reply. no this is not my issue.

 

my issue that i need to insert a card visual which will show the total of % 

 

if you can see the blue card visual is working fine because the data is there in my excel data. but when i try to choose insert card visual for % nothing is showing because the % i created it based on the row total and there is no data in my original data set

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi anglefbi11 ,
You can change the measure to something like this:

Total ppercentage of alert = 
VAR a = 
CALCULATE(
    SUM('Table'[Alert]),
    ALL('Table')
)
RETURN
SUM('Table'[Alert])/a

Put in matrix and a card

 

Best regards,
Albert He

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

 

  • anglefbi11's avatar
    anglefbi11
    Helper I
    2 years ago

    godbless you brother

    i dont know how to thank you. thank you for your attached file and for your kind responses 

     

    thank you veeeeeeeeeery much you solved my issue