topic How to calculate MAX on a Selected ALL column? in DAX Commands and Tips

How to calculate MAX on a Selected ALL column?

Anonymous — Fri, 26 Mar 2021 10:03:57 GMT

Hi,

I want to create a DAX query for the below table

The query should calculate = Selected Model (Score) / Max(Score) *.4
Hence

For A = 4/4*.4

For B = 3/4*.4

For C = 2/4*.4

IS there a way to calculate the max on a column with specific model scores like above?

Thanks for the help

Anonymous — Fri, 26 Mar 2021 10:23:45 GMT

CalculatedColumn = 'Table'[Score]/MAX('Table'[Score]) * .4

Anonymous — Fri, 26 Mar 2021 13:08:59 GMT

Anonymous — Tue, 30 Mar 2021 06:30:19 GMT

Thanks for the solution.

I have used the above query with a slight change

Calculated Colum = 'Table'[Score]/calculate(MAX('Table'[Score], ALLSELECTED()))*0.4

This helps me with calculating the selected values and work with filters as well.