Filtering indirect relationship

[olofu]

Hello to everyone,

I'm creating a dashboard coming from my project management software but I can't create a unique filter for all the graphics.

As you can see in the screen I would like to create a filter from the table "vtiger_aree" based on "siglasottoarea" column.

Of course it is not working for the indirect relationship between "vtiger_aree" and "Sub/Prev_OK" table but power bi doesn't allow me to activate this relationship.

How can I do?

Thank you in advance

[negi007]

@olofu you will have to specify this in the measure that you will be creating from these tables. You can use userelationship function to activate relationship between these two tables

for more on this, refer to below link

Active vs inactive relationship guidance - Power BI | Microsoft Docs

[olofu]

@negi007 

I don't know if I get the point

Should I create a new column with the userelationship formula? In which table?

[negi007]

@olofu no need to create a new column, you just need to create a new measure there you can use this function userelationship.