Forum Discussion
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...
Anonymous
Can you please provide a dummy dataset or PBIX file to play around with?
Here is the sample data I used.
As well as that measure for the card:
RED =
VAR METRIC_1 =
COUNTROWS(
FILTER(
SUMMARIZE(
'Metric 1', 'Metric 1'[Region],"1", SUM('Metric 1'[AVG])), [AVG_MEASURE]<=.75))
VAR METRIC_2 =
COUNTROWS(
FILTER(
SUMMARIZE(
'Metric 2','Metric 2'[Region],"2",SUM('Metric 2'[AVG_2])),'Metric 2'[AVG_MEASURE2]<=.75))
VAR GRIDS_RED = METRIC_1 + METRIC_2
RETURN IF(ISBLANK(GRIDS_RED),0,GRIDS_RED)