Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have the following table:
Here ID and Product numbers are columns and Total Count of runs is a Dynamic measure which gives the count based on some calculations.
Id | Product Nr | Total Count of runs |
R1114 | 514543 | 1 |
R6004 | 514543 | 1 |
R8113 | 514543 | 5 |
R1114 | 525497 | 5 |
R6020 | 525497 | 3 |
R8113 | 525497 | 17 |
I need to create a Measure that gives me the MAX of the Total count of runs per product number
Id | Product Nr | Total Count of runs | MAXCount |
R1114 | 514543 | 1 | 5 |
R6004 | 514543 | 1 | 5 |
R8113 | 514543 | 5 | 5 |
R1114 | 525497 | 5 | 17 |
R6020 | 525497 | 3 | 17 |
R8113 | 525497 | 17 | 17 |
I tried the combinations of ALL, ALL SELECTED, ALL Execpt, SUmmarize, MAX, MAXX, but seems they are not working as intened. Also, tried measures such as
Solved! Go to Solution.
Hi @Prathameshsable ,
Please try this DAX:
_MAX =
MAXX(ALLEXCEPT('Table', 'Table'[Product Nr]), [Measure])
The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Prathameshsable ,
Please try this DAX:
_MAX =
MAXX(ALLEXCEPT('Table', 'Table'[Product Nr]), [Measure])
The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, it got solved the same day itself. Thank you for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |