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.
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.
Go to Solution.
Hi @AndreaH ,
Please refer to my pbix file to see if it helps you.
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.
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.
View solution in original post
Hi @v-polly-msft ,
This is what I need!! Thank you so much!! I have been working this for few weeks.
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!