Forum Discussion

tnarenderr's avatar
tnarenderr
Frequent Visitor
3 years ago

Select max value for dynamic filter

Type Mod Combo Value   Tre Com Tre - O G 12681.37   Tre Com Tre - R G 14357.00   Tre Com Tre - R O 11546.18   Tre Com Tre - O B 12883.55   Tre Com Tre - O G 1...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi tnarenderr ,

 

Try formula like below:

M_ = 
CALCULATE (
    MAX ( 'Table'[Value] ),
    ALL ( 'Table' ),
    'Table'[Combo] = SELECTEDVALUE ( 'Table'[Combo] )
)

M2 =
VAR sel_mod =
    SELECTEDVALUE ( 'Table'[Mod] )
VAR sel_combo =
    SELECTEDVALUE ( 'Table'[Combo] )
RETURN
    CALCULATE (
        MAX ( 'Table'[Value] ),
        ALL ( 'Table' ),
        'Table'[Mod] = sel_mod
            && 'Table'[Combo] = sel_combo
    )

 

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.