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.
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.
This works as a charm, thank you!
