Calculated column filter rows based on row values

[Anonymous]

I am trying to calculate a calutated column which goes like this

(row - min(row))/(max(row) - min(row))

It works perfectly

What I want is that I have another column called number with number 1, 2, 3

I want to populate above thing with number as the filter such that for rows with number 1

min(row) is minimum value for row where number is 1 and so on

Thank you for any help on this!

[atul9063]

1) Instead of creating calculated column, create measures to fo such calculations (row - min(row))/(max(row) - min(row))

2) You can use below measures to filter data

selectedMeasure = SELECTEDVALUE(Table[ColumnName])

MetricFIlter = SWITCH( TRUE(),
[selectedMeasure]="1", [DailyActiveUsers],
[selectedMeasure] ="2", [DailyCallingActiveUsers]

BLANK())

[Anonymous]

I do not understnad two things,

first

a measure to calculate (row- row(min))/(row(max) - row(min))  in a measure how to select row when I use CALCULATE it gives me an error saying I need to use aggregation?

Second

in the metric filter what is [DailyActiveUsers] column?

I appreciate your help!

Thank You.