Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Display First Instance of MAX Value for Card

Hi,   I am trying to use a measure to determine which time has the highest amount of traffic. The goal is to display the Time with the highest amount on a Card within PowerBI. The problem I run int...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi Anonymous 

     

    Try this

    Max Interval = CALCULATE(MIN(Sheet1[Time]),FILTER(Sheet1,Sheet1[Amount]=MAX(Sheet1[Amount])))

    Regards

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

Try this

Max Interval = CALCULATE(MIN(Sheet1[Time]),FILTER(Sheet1,Sheet1[Amount]=MAX(Sheet1[Amount])))

Regards

Phil

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ugh. I had the wrong filter. Thank you.