Forum Discussion
Check highest value for multiple fields
I'm working on a requirement to find the highest value out of the Quarter & Name using a Result value to check. I've managed to get it to work to an extent, by which it looks at the highest value per...
Please try this approach
IsHighest =
VAR thisresult =
SUM ( Table1[Result] )
VAR quartermax =
MAXX ( ALLSELECTED ( Table1[Quarter] ), CALCULATE ( SUM ( Table1[Result] ) ) )
RETURN
IF ( thisresult = quartermax, 1, 0 )If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
amitchandak
Super User
Super UserAnonymous , I think you need to replace qtr with with month , then on top of month it will give max
CopyCheckMinMax =
VAR temp_table =
SUMMARIZE (
ALLSELECTED (
Table1[Month],
Table1[Name]
),Table1[Event Log], Table1[Name],
"@Total", SUM ( Table1[Result] )
)
RETURN
IF (
MAXX (
temp_table,
[@Total]
)
= SUM ( Table1[Result] ),
1,
0
)Hi amitchandak thanks for you reply. There isn't a Month to choose from unfortunately so this wouldn't work.