Forum Discussion

Philwantling's avatar
Philwantling
Frequent Visitor
9 years ago

Cards & ranking

Hi, hoping you can help.

 

I've got a table with several columns. Amongst the table is a column named 'Cabinet' and another named 'Red Max Amps' and another column for the date.

 

Each cabinet has a Red Max Amp number for each day, showing the highest number of amps drawn in power over the course of that day,

 

I can use a card to show the Maximum value from the Red Max Amp column, but how do i show which cabinet it came from?

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Philwantling'

     

    You can create another measure to show the cabinet with max Amp.

     

    Please refer to sample below:

     

    Text with Max Number = CALCULATE(MAX(Table1[Text]),FILTER(Table1,Table1[Number]=MAX(Table1[Number])))

     

     

    Regards,