Apply same filter different dimensions

[wribeiro]

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?

[lbendlin · Accepted solution]

Read about TREATAS() TREATAS function - DAX | Microsoft Docs