Calculate MAXX from a dynamic measure

[Prathameshsable]

Calculate MAXX from a Dynamic Measure

yesterday

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 

MAXTotalcountofruns =

MAXX (

    VALUES ( Conversion[Product Nr] ),

    [Total count of runs]

)
Got the following output (which doenst work as well)

MAXTotalcountofruns =

VAR _a =

    MAXX(

        SUMMARIZE('Conversion', 'Conversion'[Product Nr], "MaxCount", [Total Count of runs]),

        [MaxCount]

    )

RETURN

    IF(

        HASONEVALUE('Conversion'[Product Nr]),

        _a,

        BLANK()

    )

Need help to solve the above problem.

I have checked for various articles and videos but none of them help (majorly all videos are towards column creation only. 

thanks

[Anonymous · Accepted 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.

[Prathameshsable]

Yes, it got solved the same day itself. Thank you for your help