find min and max by group and continuous order

[mim]

using DAX how to calculate min and max for this table, based on the attribute color and they have to be in the same sequence , for example red -3 and red -6 are not considered in the same group as 3 and 6 are not in a continuous order

[Mariusz · Accepted solution]

Hi @mim 

Please see the attached file with the solution.

The file contains
Calculated column

rankColorGroup = 
VAR __previousColor = 'Table'[color]
RETURN
    RANKX (
        FILTER ( 'Table', 'Table'[color] <> __previousColor ),
        'Table'[order],,,
        DENSE
    )

Two Measures

min = 
CALCULATE(
    MIN( 'Table'[order] ),
    ALL( 'Table' ),
    VALUES( 'Table'[rankColorGroup] )
)

max = 
CALCULATE(
    MAX( 'Table'[order] ),
    ALL( 'Table' ),
    VALUES( 'Table'[rankColorGroup] )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Anonymous]

Hi, I tried to use solution proposed but when individual values are one after another there is an error in calculation. Do you have some idea how to fix this, I have no idea how to fix this.