Forum Discussion
Hi All,
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:
Super Userhi 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:
Solution SageNice a very simlar way to solve it 🙂