Forum Discussion
Apply same filter different dimensions
Hi guys, I need help to solve something here.
Red table are fact tables
Green table is a Parent table based on Location table.
OneToMany is represented by arrows.
The problem is Type tables (type parent and Type Location)
If I apply filter on Type Location, i need that the same filter has been applied at Type parent.
I cannot create a join between that because it will be create a circle relationship. I cannot use just one share table because it will create a circle relashionship.
I need to do that because I have two fact tables in different levels, right, however, I would like to apply same filter in both of than.
Could you help me to solve it?
Read about TREATAS() TREATAS function - DAX | Microsoft Docs
1 Reply
- lbendlinSuper User
Read about TREATAS() TREATAS function - DAX | Microsoft Docs