DAX Max value from another column based on row value

[sentsara]

Hi ,

Need help on DAX Expression to repeat MAX Values of column2 in column3 .

Dataset Name: Measure

COLUMN1 COLUMN2   Column3 <DAX Expression needed>

1            25

2             35

3            70

4           15

5           45

expected output:

COLUMN1 COLUMN2   Column3 <DAX Expression needed>

1            25                       70

2             35                      70

3            70                       70

4           15                       70

5           45                         70

[Anonymous · Accepted solution]

Use this DAX formula:

Column3 = CALCULATE(MAX(Table1[Column2]),ALL(Table1[Column2]))

Thanks

Raj

[sentsara]

Thanks Rajendran.

IF col2 is calculated expression also ,I think we can apply the same expression. can you confirm on this?

[v-jiascu-msft]

Hi @sentsara,

Only the main part is needed in the calculated column.

column3 = MAX(Table1[Column2])

Best Regards,

Dale

[Anonymous]

Yes, Calculated column also can be used there.

Thanks

Raj