Forum Discussion

tomsmith213's avatar
tomsmith213
Frequent Visitor
3 years ago

A Card Visual That Relates to Another Measure

Hi, I have finally managed to create a measure that reads out the higest value (I'm new lol) but now I need another card visual that reads out the supervisors name.

 

Any ideas how to go about this, so when i select a card visual and drag in a measure it will read the supervisors name that relates to the 91% score?

 

 

 

Need Help

3 Replies

  • djurecic's avatar
    djurecic
    Super User
    3 years ago

    Hi tomsmith213 ,

     You can try something like this:

    Please adjust for your table and column names

     

    Max Utilitisation Supervisor= CALCULATE(MAX(TableName[Supervisor Name]), FILTER(ALL(TableName), Tablename[% Shift]= [max utilisation]))

    • tomsmith213's avatar
      tomsmith213
      Frequent Visitor
      3 years ago

      Hi, thanks for the reply, but where have I gone wrong?

       

       

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    tomsmith213 ,

    Just Noticed djurecic , Already replied. Please check that solution first , Please check this only if that did not work.

    Create a TOPN Measure

     

    Top Utilization % =

    CALCULATE( [Utilization %] ,TOPN(1,allselected('Table'[Supervisor]), [Utilization % ,DESC),values('Table'[Supervisor]))

     

    Supervisor

    CALCULATE( max('Table'[Supervisor]) ,TOPN(`,allselected('Table'[Supervisor]), [Utilization % ,DESC),values('Table'[Supervisor]))

     

    or

     

    maxx(TOPN(`,allselected('Table'[Supervisor]), [Utilization % ,DESC), [Supervisor])