Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Card Visual (Measure with Distinct Count)

Hi all, I need some help creating a measure for a card that call outs Regions in Red. There are only 7 Regions, so the maximum would be 7. Right now, the measure I have created sums up everything th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi all,

I need some help creating a measure for a card that call outs Regions in Red. There are only 7 Regions, so the maximum would be 7. Right now, the measure I have created sums up everything that is in Red. In the example below, my Card says there are 7 Regions in Red (7 red icons). This is incorrect. I need it to say 6 Regions in Red with no duplicates of the regions. I basically need a distinct count of the Regions in Red which I am having trouble figuring out how to add to my measure. For reference, Metric 1 and Metric 2 are in seperate tables.

I have tried multiple ways to get what I want, but I'm having trouble. If anyone has any guidance for me, that'd be great.

Here's my measure for the card so far:

AFF_RED =
VAR Metric 1_RED = COUNTROWS(FILTER(SUMMARIZE(
'Metric 1', 'Metric 1[Region],"Metric 1", SUM('Metric 1'[Average_Days_COL])), [Average_Days]>33))
VAR Metric 2_RED = COUNTROWS(FILTER(SUMMARIZE(
'Metric 2','Metric 2[Region],"Metric 2",SUM('Metric 2'[Rate_COL])),[Rate]>1))
VAR REGIONS_RED = Metric 1_RED + Metric 2_RED
RETURN IF(ISBLANK(REGIONS_RED),0,REGIONS_RED)