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.
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 |
Solved! Go to 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.
Hi @v-rongtiep-msft ,
This is what I need!! Thank you so much!! I have been working this for few weeks.
Really appreicate.
Andrea
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
107 | |
74 | |
66 | |
49 | |
48 |
User | Count |
---|---|
164 | |
87 | |
77 | |
70 | |
67 |