Forum Discussion
Obtain the maximum value of a Measure
Hi all ! How are you?
How can I get the maximum value of a measure?
The measure can be affected by date filters, country, store.
The example is as follows:
In this case, the value of store A is the highest, but if I select more stores, the highest value can be another.
The highest value I need to use to be the denominator of a division.
Regards!!
- Replace value function with all
5 Replies
- parry2k
Super User
Anonymous it can be very tricky to answer based on your question. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490- parry2k
Anonymous try this
Highest Value measure = MAXX ( VALUES ( Table[Store] ), [Your Measure] )Hi parry2k !
This way:
Highest Value measure = MAXX ( VALUES ( Table[Store] ), [Your Measure] )It only works if I use the measurement on a card.
If I add the measurement to my table, it shows me the same values as the total for each store.I need to use the higher value (6.6 in this example) to use it as denominator in the next division:
Division = (Total / Hightest Value measure)Regards!