Forum Discussion
jerryr125
Helper IV
Helper IVdisplaying a description in a measure based upon another variable
Hi - I would like to create a measure that displays a description based upon the maximum amount of a variable. As an example of values in a data table: Flavor Amount Vanilla 20000 C...
Thank you, Deku , for your response.
Hi jerryr125,We appreciate your query posted on the Microsoft Fabric Community Forum.
In addition to the response provided by Deku , please find below the DAX measure which may help resolve the issue:
FlavorWithMaxAmount =
CALCULATE(
SELECTEDVALUE('Table'[Flavor]),
FILTER(
'Table',
'Table'[Amount] = MAX('Table'[Amount])
)
)
If you find our response helpful, we kindly request you to mark it as the accepted solution and consider giving kudos. This will assist other community members who may have similar queries.
Thank you.
Deku
Super User
Super UserFlavour with highest amount=
MAXX(
Topn(
1,
Table,
Table[amount],
Desc
),
Table[flavour]
)