Forum Discussion
Solved
Retrieving Column Values When a Measure Reaches Its Maximum
There are two numerical columns, Amount1 and Amount2, along with a category and size as shown in the figure. I will create a measure (Measure 0) that changes based on parameters selected by the user ...
Hi mh20221111
You can create a measure.
Diff = VAR a = SUMMARIZE ( ALLSELECTED ( table ), [Category1], [Size], [Amount1], "Max0", [Measure0] ) VAR b = MAXX ( TOPN ( 1, FILTER ( a, [Category1] IN VALUES ( table[Category1] ) ), [Max0], DESC ), [Amount1] ) RETURN SUM ( table[Amount1] ) - bBest Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mh20221111
You can create a measure.
Diff =
VAR a =
SUMMARIZE (
ALLSELECTED ( table ),
[Category1],
[Size],
[Amount1],
"Max0", [Measure0]
)
VAR b =
MAXX (
TOPN (
1,
FILTER ( a, [Category1] IN VALUES ( table[Category1] ) ),
[Max0], DESC
),
[Amount1]
)
RETURN
SUM ( table[Amount1] ) - b
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I was able to implement what I wanted to do using the method you explained. Thank you for your guidance.