Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |