Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to mark a record if it has the highest iteration in a group. It would look like the last column in this table.
Location | Iteration | Live |
A | 1 | NL |
A | 1 | NL |
A | 2 | NL |
A | 2 | NL |
A | 3 | L |
A | 3 | L |
B | 1 | NL |
B | 1 | NL |
B | 2 | NL |
B | 2 | NL |
B | 3 | L |
Please let me know if someone has a solution. Thanks!
Solved! Go to Solution.
Hi @MattRoed ,
Create a Calculated Column
Highest in Group =
var a = CALCULATE(MAX('Table'[Iteration]), FILTER ('Table','Table'[Location] = EARLIER('Table'[Location])))
RETURN
IF ( 'Table'[Iteration] = a , "L","NL")
Incase you want a measure
Highest in Group M =
var a = CALCULATE(MAX('Table'[Iteration]), FILTER (ALL('Table'),'Table'[Location] = MAX('Table'[Location])))
RETURN
IF ( MAX('Table'[Iteration]) = a , "L","NL")
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Hi @MattRoed ,
Create a Calculated Column
Highest in Group =
var a = CALCULATE(MAX('Table'[Iteration]), FILTER ('Table','Table'[Location] = EARLIER('Table'[Location])))
RETURN
IF ( 'Table'[Iteration] = a , "L","NL")
Incase you want a measure
Highest in Group M =
var a = CALCULATE(MAX('Table'[Iteration]), FILTER (ALL('Table'),'Table'[Location] = MAX('Table'[Location])))
RETURN
IF ( MAX('Table'[Iteration]) = a , "L","NL")
Regards,
Harsh Nathani
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Not sure if this is what you are looking for, but you could add a calculated column:
Live = IF('Iterations'[Iteration]=MAX([Iteration]), "L", "NL")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |