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 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!
2 Replies
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.
