Forum Discussion
Solved
Hi All,
I have a column named pp having numeric values 0 till 12. This pp column is acting as a slicer. Now I want to create the dynamic column let's say if I selected 5 from pp slicer then dynamic column sh...
hi sd22
it hides some complexity,
1) supposing you have a Table1 like:
2) try to create another table2 with pp2 column, exactly the same value, but do not relate them.
3) write a measure like:
measure = VAR _value2 = SELECTEDVALUE(Table2[pp2]) VAR _value1 = MAX(Table1[pp]) RETURN IF( _value1<=_value2, 1, 0)4) plot a slicer with table2[PP] and a table visual with table1[PP]. Choose not summarize for the table visual. Feed the measure to the filter pane of the table visual and choose 1. it worked like:
andhiii079845
Solution Sage
Solution SageHi,
i create a second table "slicer" with the pp values and use it in the slicer. I create a measure with following code
Measure =
VAR _selectvalue = CALCULATE(SELECTEDVALUE(Slicer[pp]))
VAR _pp = sumx(FILTER('Table','Table'[pp]<=_selectvalue),'Table'[pp])
RETURN _pp
To verfiy the result:
Than use the measure as a filter:
There has to be NO relationship between both tables.