Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Displaying cards based on top 2 value dynamically

Hi guys,   I am facing a challenge in displaying two card visual. I have four columns in my dataset i.e Division, category, manufacturer and sales.   Division and category will be the slicers in ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

     

    To exclude M1 from the rank, use:

    Manuf. Rank = 
VAR _RANK= RANKX(
             FILTER(ALLSELECTED('Fact Table'), 'Fact Table'[Manufacturer] <> "M1"), 
              [Sum Sales],,DESC,Dense)
RETURN
IF(ISINSCOPE('Fact Table'[Manufacturer]), _RANK)   // To Exclude from the "Total" row

     

    Create your matrix, and exclude M1 in the filter for Manufacturer in the filter pane, and set the rank to "less than 3"

     

    I've included the PBIX file for you to check out.

v-xuding-msft's avatar
v-xuding-msft
Community Support
5 years ago

Hi Anonymous ，

 

Have you resolved it? If yes, please accept the helpful answer as solution. Others will benefit from this thread. Thanks! If you still need help, please feel free to ask us.