Forum Discussion
Solved
Filters - Relevant Data Only?
I have 3 fact tables with 1 to many relationships to my data table. On the Filters pane, I want the fact table choices to only show the data relevant to the data table. For example Data Tab...
Hi hgromek ,
I created some data:
Data Table:
Fact Table:
Here are the steps you can follow：
1. Create measure.
Measure = IF( MAX('Data Table'[ColorID]) in SELECTCOLUMNS('Data Table',"colorid",'Data Table'[ColorID]),1,0)2. Place the measure in Filters, set is =1, apply filter.
3. Result:
Only display the content in the Data Table.
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 hgromek ,
I created some data:
Data Table:
Fact Table:
Here are the steps you can follow：
1. Create measure.
Measure =
IF(
MAX('Data Table'[ColorID]) in SELECTCOLUMNS('Data Table',"colorid",'Data Table'[ColorID]),1,0)2. Place the measure in Filters, set is =1, apply filter.
3. Result:
Only display the content in the Data Table.
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