How to calculate MAX on a Selected ALL column?

[Anonymous]

Hi,

I want to create a DAX query for the below table

Model	Score
A	4
B	3
C	2

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 · Accepted solution]

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

[Anonymous]

How to Get Your Question Answered Quickly (powerbi.com)

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

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.