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
Solved! Go to 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] )
)
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] )
)
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.