Calculate Score based on Value shown in the Group of Card Visuals

[prabhatnath]

Hi Friends,
I have say 9 card visuals in the report that shows the value from dataset columns based on some filter (like Card1 will show Count of Field1 value is Null, Card 2 will show Count of Field2 value < Current Date etc.) or a Calculated value from a Measure. The value that will be shown on the Cards will be either ZERO or a Positive Number.

I want to show another Card that will show the score like: 9/9 (if all 9 cards have zero values) or 5/9 (if 5 cards have zero and 4 cards have positive numbers). How can I achieve this? 

Thanks,

Prabhat

[v-zhangti · Accepted solution]

Hi, @prabhatnath 

You can create a measure that checks if the value of each card is zero or not. For example, if the value of Card1 is zero, then the measure will return 1, otherwise, it will return 0. You can then sum up the values of all the cards and divide it by the total number of cards to get the score. Here is an example of the measure:

Score = 
VAR Card1 = IF([Value of Card1] = 0, 1, 0)
VAR Card2 = IF([Value of Card2] = 0, 1, 0)
VAR Card3 = IF([Value of Card3] = 0, 1, 0)
VAR Card4 = IF([Value of Card4] = 0, 1, 0)
VAR Card5 = IF([Value of Card5] = 0, 1, 0)
VAR Card6 = IF([Value of Card6] = 0, 1, 0)
VAR Card7 = IF([Value of Card7] = 0, 1, 0)
VAR Card8 = IF([Value of Card8] = 0, 1, 0)
VAR Card9 = IF([Value of Card9] = 0, 1, 0)
RETURN
SUM(Card1, Card2, Card3, Card4, Card5, Card6, Card7, Card8, Card9) & "/" & COUNTROWS('Table')

Best Regards,

Community Support Team _Charlotte

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