Forum Discussion
Calculated column filter rows based on row values
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 num...
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())
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.