Forum Discussion

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

Community Support

3 years ago

Hi tnarenderr ,

Try below:

slicer1 = CROSSJOIN(row("slicer","tyep"),VALUES('Table'[Combo]))

slicer2 = CROSSJOIN(row("slicer","type"),VALUES('Table'[Mod]))

result =
CALCULATE (
    MAX ( 'Table'[Value] ),
    ALL ( 'Table'[Value] ),
    ALLSELECTED ( 'Table'[Combo], 'Table'[Mod] )
)