Forum Discussion
J_o_n_a_s
Helper I
Helper INeed help with a measure
Hi all. I'm quite new to Power BI so I hope this isn't a stupid question. This table is a simplified version of what I am dealing with: Project Number Work Ordered by Team Work Done by T...
Which team ordered the most work in total?
Measure = VAR __Table = SUMMARIZE('Table',[Work Ordered by Team],"Hours",SUM([Hours Worked])) VAR __Max = MAXX(__Table,[Hours]) VAR __Team = MAXX(FILTER(__Table,[Hours] = __Max),[Work Ordered by Team]) RETURN __TeamThe rest are going to be variations on that theme. This is an example of Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
Greg_Deckler
Community Champion
Community Champion
Which team ordered the most work in total?
Measure =
VAR __Table = SUMMARIZE('Table',[Work Ordered by Team],"Hours",SUM([Hours Worked]))
VAR __Max = MAXX(__Table,[Hours])
VAR __Team = MAXX(FILTER(__Table,[Hours] = __Max),[Work Ordered by Team])
RETURN
__Team
The rest are going to be variations on that theme. This is an example of Lookup Min/Max - https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/m-p/985814#M434
J_o_n_a_sHelper I
Helper IThank you Greg_Deckler and amitchandak.
I found Greg's explanation easier to understand and implement. For question 3 and 4 i then just used a slider to filter from which team's perspective I want to see the results.