Maxx of a dynamic measure with all selected not working

[Prathameshsable]

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

[Ashish_Mathur]

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.

[Prathameshsable]

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

[Ashish_Mathur · Accepted solution]

Those answers seem correct.  For 437725, the max is 2 and for 437745, the max is 3.

[Prathameshsable]

Yes, it was solved the same day with the same measure. Sorry for the late response and thanks for the measure.

[Prathameshsable]

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