DAX Max value

[topazz11]

Hi.

I thought it was easy, but somehow I can't get it to work.

I have a table with 3 value columns.

I want to add another Column which shows the maximum number among the 3 values columns.

Tried a column and measure...it could show each row but doesnt show summary level correctly.

here is the pbix file and screen shot.

Could you help me?

Thanks,

PBIX file 

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[VahidDM · Accepted solution]

Hi @topazz11 

try this measure:

Measure_Max Value = 
Var _A = sum('Table'[Value1])
Var _B = sum('Table'[Value2])
var _C = sum('Table'[Value3])
return
max(max(_A,_B),_C)

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!