Forum Discussion
Resolver IIFind max in a group based on a condition
Hi kasiaw29 ,
Based on your description, you can create this measure, put it in the visual filter and set its value as 1:
Measure = VAR _max = CALCULATE ( MAX ( 'Table'[Baseline Revision No] ), ALLEXCEPT ( 'Table', 'Table'[Project] ), 'Table'[Cus Search] = 1 ) VAR _br = SELECTEDVALUE ( 'Table'[Baseline Revision No] ) RETURN IF ( _br = _max, 1, 0 )Attached a sample file in the below, hopes to help you.
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
I have had help on a spanish version of community.
I've changed my LC Max to include following:
LC Max = CALCULATE(MAX('Activity History'[Baseline Revision No]),FILTER(ALLEXCEPT('Activity History','Activity History'[Project]),'Activity History'[CUS Search] = 1))Then I have created a custom column with this:Max Baseline CA = IF('Activity History'[Baseline Revision No] = 'Activity History'[LC Max],1,0)
Community SupportHi kasiaw29 ,
Based on your description, you can create this measure, put it in the visual filter and set its value as 1:
Measure =
VAR _max =
CALCULATE (
MAX ( 'Table'[Baseline Revision No] ),
ALLEXCEPT ( 'Table', 'Table'[Project] ),
'Table'[Cus Search] = 1
)
VAR _br =
SELECTEDVALUE ( 'Table'[Baseline Revision No] )
RETURN
IF ( _br = _max, 1, 0 )
Attached a sample file in the below, hopes to help you.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Resolver III have had help on a spanish version of community.
I've changed my LC Max to include following: