Show the first bigger value

[ezequiel]

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. Ideally would be to show it as a Card.

I can't transform the original query as I need to use other data of the table to show information (A).  And I can't have a different query for this as I need to use the same filters I'm using on (A).

Any help on how to solve this?

Thanks!

Ezequiel

[v-chuncz-msft]

@ezequiel,

You may use TOPN Function as well.

Measure =
MAXX ( TOPN ( 1, Table1, Table1[Sales], DESC ), Table1[Day] )

[ezequiel]

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]

@ezequiel,

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

[ezequiel]

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

[v-chuncz-msft]

@ezequiel,

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

[Zubair_Muhammad · Accepted solution]

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] ) )