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 SageThis is a completey new question right? -> perhaps a new topic?
Hi andhiii079845,
Yes this can be considered as a new query because I thought creating dynamic calculated column
Yes this can be considered as a new query because I thought creating dynamic calculated column
will work but as no relation is there . It is not working.
This can be treated as a new question. Kindly help me with this.
Thanks & Regards
This can be treated as a new question. Kindly help me with this.
Thanks & Regards
Sd22
- andhiii079845
Are you able to upload the .pbix with sample data? So I do not have to copy it for my own.