Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Expert,
I have one calculated measure on which I want to calculate MAX of this measure with respect to the filter selected by users.
Input fields:
Measure Name = Profit Measure
Filters/Slicers available = Region, Week, Channel
Output:
Max of the Profit Measure based on values selected by users in those filters
I would really appreciate your help.
P.S. I tried with MAXX along with ALLSELECTED/REMOVEFILTERS/SUMMERIZE but nothing worked.
Solved! Go to Solution.
@Uzi2019 You can also try this measur:
Measure = MAXX(ALLSELCTED(TableName),[Profit Measure])
@Uzi2019 You can also try this measur:
Measure = MAXX(ALLSELCTED(TableName),[Profit Measure])
@Uzi2019 , Seem like @johnt75 has replied before me. So consider that reply before checking this. In case that does not solve the purpose, then consider this
You need to have something like this
Switch( True(),
selectedvalue(Slicer[Slicer]) ="Region", maxx(values(Table[Region]), [Measure]) ,
selectedvalue(Slicer[Slicer]) ="Week", maxx(values(Table[Week]), [Measure]) ,
selectedvalue(Slicer[Channel]) ="Week", maxx(values(Table[Channel]), [Measure])
)
It depends on which column or columns you want to group by. If you are only grouping by 1 column then you could use
Max profit =
MAXX ( VALUES ( 'Table'[Column] ), [Profit] )
If you are grouping by more than 1 column then use
Max Profit =
MAXX ( SUMMARIZE ( 'Table', 'Table'[Column 1], 'Table'[Column 2] ), [Profit] )
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |