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,

 

You may use TOPN Function as well.

Measure =
MAXX ( TOPN ( 1, Table1, Table1[Sales], DESC ), Table1[Day] )
ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Thanks for the help. I customized the measure script to my tables to

 

Measure = MAXX( TopN (1, Last_30_days_activity, Last_30_days_activity[# of Requests], desc), Last_30_days_activity[weekDay] )

 

but I'm getting a sintax error....any clue on what is wrong?

 

Thanks again

  • 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.