Need MAX to recalculate by filter

[AndreaH]

Hello everyone,

I am new to Power BI DAX.😊

I am trying to recalculate MAX efficiency when select HP. (I have a slicer to allow to select mutiple)

But I can only do the MAX calculate by category.

Max Efficiency (Category) =

CALCULATE(

MAX(Combine[Efficiency]),

ALLEXCEPT(Combine,Combine[HP]))

Ex: If I select HP1 and 1.5, MAX efficiency will recalculate to 1 & 1.5's MAX efficiency. Not the MAX by category.

I think I am missing some formate, pleaes help me to solve this issue.

THANK YOU!😄

Manufacture	Model Number_1	HP	Poles	Efficiency
A	AB	1	8	0.785	0.886
A	AC	1	2	0.84	0.886
A	AD	1	4	0.875	0.886
A	AE	1	6	0.825	0.886
A	AF	1.5	8	0.8	0.886
A	AG	1.5	2	0.883	0.886
A	AH	1.5	4	0.886	0.886
A	AI	1.5	6	0.875	0.886
G	GM1	1	4	0.865	0.886
G	GM2	1	6	0.825	0.886
G	GM3	1	2	0.875	0.886
G	GM4	1	8	0.8	0.886
G	GM5	1.5	4	0.865	0.886
G	GM6	1.5	2	0.875	0.886
G	GM7	1.5	6	0.875	0.886
G	GM8	1.5	8	0.8	0.886
M	M12	1	2	0.825	0.886
M	M13	1	4	0.855	0.886
M	M14	1	6	0.825	0.886
M	M15	1	8	0.755	0.886
M	M16	1.5	2	0.865	0.886
M	M17	1.5	4	0.865	0.886
M	M18	1.5	6	0.875	0.886
Manufacture	Model Number_1	HP	Poles	Efficiency	Max
A	AB	1	8	0.785	0.875
A	AC	1	2	0.84	0.875
A	AD	1	4	0.875	0.875
A	AE	1	6	0.825	0.875
G	GM1	1	4	0.865	0.875
G	GM2	1	6	0.825	0.875
G	GM3	1	2	0.875	0.875
G	GM4	1	8	0.8	0.875
M	M12	1	2	0.825	0.875
M	M13	1	4	0.855	0.875
M	M14	1	6	0.825	0.875
M	M15	1	8	0.755	0.875

[AndreaH]

Hi @v-polly-msft ,

This is what I need!! Thank you so much!! I have been working this for few weeks.

Really appreicate.

Andrea

[v-polly-msft · Accepted solution]

Hi @AndreaH ,

Please refer to my pbix file to see if it helps you.

Create measures.

bot_ =
CALCULATE (
    MAX ( 'Table'[Efficiency] ),
    FILTER ( ALL ( 'Table' ), 'Table'[HP] IN VALUES ( 'Table'[HP] ) )
)

Measure 2 = MAXX(ALLSELECTED('Table'),[bot_])

If I have misunderstood your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

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