Forum Discussion

olofu's avatar
olofu
Frequent Visitor
4 years ago

Filtering indirect relationship

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

3 Replies

    • olofu's avatar
      olofu
      Frequent Visitor

      negi007 

      I don't know if I get the point

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

       

      • negi007's avatar
        negi007
        Community Champion

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