Forum Discussion
Solved
restrict the data in a filter visual from one table with data present only in another table
I have a dimension table containing all the states present in my Power BI, and in other tables I have different states. I would like to use the state column of the dimension table to create a visual ...
Hi psorel ,
Are you referring to using [ID] data from another table to affect the [ID] in the dimension table as a slicer
Here are the steps you can follow：
1. Create measure.
Flag = var _select=SELECTCOLUMNS('Table1',"id",'Table1'[ID]) return IF( MAX('dimension table'[ID]) in _select,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi psorel ,
Are you referring to using [ID] data from another table to affect the [ID] in the dimension table as a slicer
Here are the steps you can follow：
1. Create measure.
Flag =
var _select=SELECTCOLUMNS('Table1',"id",'Table1'[ID])
return
IF(
MAX('dimension table'[ID]) in _select,1,0)2. Place [Flag]in Filters, set is=1, apply filter.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly