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 brother

 

sorry for bothering  you

 

can you asset me to write a new messure by doing the below

i want to say ( take the number in blue row under header 50 ( 7 )  and devide it by  the total (5428) and * 100

 

the above messure will solve my issue. because in my data set i dont have a column for this calculation .

 

you can refer to the below image so you can understand what i mean. because if i did this messure i can add it in my card visual

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi anglefbi11 ,
Thanks for the reply. You can try this MEASURE

 

Percentage = 
VAR a = 
CALCULATE(
    MAX('Table'[Alert]),
    FILTER(
        'Table',
        'Table'[Name] = "A" && 'Table'[Number] = 1
    )
)
VAR b = 
CALCULATE(
    SUM('Table'[Alert]),
    FILTER(
        'Table',
        'Table'[Name] = "A"
    )
)
RETURN
a/b

 

Final output


This is a new question, and a post corresponding to an answer would allow other members with similar questions to get more accurate help. If the above suggestions don't solve your new problem.You can create a new post and a professional engineer will solve the problem for him.

 

Best regards,
Albert He