Forum Discussion
Solved
Filter dimensional data based on other dimension value without using facts (in a star schema)
Hello everyone, I have an (I think) complex issue with filtering a table/matrix that does not contain fact data. My model is a star schema with fact table 'invoice' and dimensional tables 'product...
Hi KaySunset ,
You can try the following formula:
Here are the steps you can follow：
1. Create measure.
Measure = var _selected=SELECTCOLUMNS(ALLSELECTED(Tenant),"1",[tenant]) return IF(MAX('Customer'[Tenant]) in _selected||MAX('Product'[tenant]) in _selected,1,0)2. 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.
Hello, I have similar issue. I want to filter one dim table with the other. Ex. If one Country is selected in one slicer, Customers belongs to that country only should be populated in Customer Slicers.
Data source is SSAS Cube data, so I cannot modify the relationship. Please suggest some workaround.
TIA