Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap
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 @Anonymous ,
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.
User | Count |
---|---|
87 | |
74 | |
69 | |
58 | |
55 |
User | Count |
---|---|
40 | |
38 | |
34 | |
32 | |
30 |