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

amitchandak I'm curious if you might have some input you could give me. I'd appreciate any help.

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , If REGIONS_RED  giving blank then count with values should count red region 

     

    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

    countx( values('Metric 1'[Region]),REGIONS_RED)

     

    or

     

    RETURN

    countx( summarize('Metric 1', 'Metric 1'[Region],"_1",[REGIONS_RED]),[_1])