Forum Discussion

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Solved

Show the first bigger value

Hi,   I have a table with all the days of the week and some values associated to them - Sales. Basically 2 columns. I just need to show the name of the day with the higher value on the sales column...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi ezequiel

     

    If you have one value against each day, these MEASURES should give you desired result in a CARD

     

    Measure =
CALCULATE (
    VALUES ( TableName[Day] ),
    FILTER ( ALL ( TableName ), TableName[sales] = MAX ( TableName[sales] ) )
)

     

    Alternate Measure  =
LOOKUPVALUE ( TableName[Day], TableName[sales], MAX ( TableName[sales] ) )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

ezequiel,

 

Replace commas ( , ) in above formula with semicolons ( ; ).

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi! didn't work...see attached error. Thanks!

 

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    ezequiel,

     

    Your original formula seems correct. If convenient, share us the simplified model.