Need Help on DAX Formula

[mthukara]

I need help in DAX formula for the below scneraio;

I have Category and value column, i need a Max value column which will repeat the max from val column irrespective of category.

In the below example 499 is the maximum value in val column and 499 should be for each record in max val column.

Category	Val	Max Val
Cat1	242	499
Cat2	499	499
Cat3	464	499
Cat4	104	499
Cat5	437	499
Cat6	131	499
Cat7	416	499
Cat8	156	499
Cat9	473	499
Cat10	295	499
Cat11	173	499
Cat12	478	499
Cat13	305	499
Cat14	478	499

[amitchandak]

@mthukara ,

Try like

Max Val =
var _max = maxx(Table,Table[Val])
return
_max

[neha369]

 Create a calculated column with following DAX formula

Max Val = MAX('Table'[Val]) 

Thanks and Regards,

Neha Rajgadkar| BI Consultant

Nice Software SolutionsPvt. Ltd.