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
PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

Can you please provide a dummy dataset or PBIX file to play around with? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Paul,

    Thanks for your willingness to help. I create a sample power bi. How should I send it? I'm not able to attach onto here. 

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      5 years ago

      Anonymous 

      You can upload the file to a cloud service (Onedrive, Google Drive, Dropbox...) and share the file from there. 
      Alternatively you can post sample data in a table format here (not as an image please) so we can copy it and work on a solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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)