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.
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 |
The above is my table, wherein Total count of runs is a dynamic measure and caculates the values dynamically. however, when I create a MAXX to create the MAX count column, it does not work. I tried creating calculcations based on summarize, allselected, values but none of them are giving the correct output. need help is solving the query
Solved! Go to Solution.
Those answers seem correct. For 437725, the max is 2 and for 437745, the max is 3.
Hi,
Does this measure work?
Measure = MAXX(ALL(Data[ID]),[Total Count of runs])
If it does not, then share the download link of the PBI file. Show the visual where you want to see this result.
not really, using the above. Because here need to look at the productNr and not ID. If you look at the below example; the max value should have been 3, but it gives 2 and 3 both
Those answers seem correct. For 437725, the max is 2 and for 437745, the max is 3.
Yes, it was solved the same day with the same measure. Sorry for the late response and thanks for the measure.
Further adding to the reply, I tried looking at various posts and comments in the community provided tried maxx(Allselected) combination as well, but they do not seem to work.
Actually I am trying to evaluate a sumproduct function in powerbi which can be achieved via sumX wherein it looks for the max value, so if I get the max value against the product number I can easily calculate the condition
@amitchandak @lbendlin @Ritaf1983 @Idrissshatila @Ashish_Mathur
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 | |
98 | |
79 | |
74 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |