Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

Modelling Q&A - Help Needed

I have the following Fact Table (small sample): Fact table is a Sharepoint table. As you can see for Tool column there are cells (lists) which collects more than one tool, like row 2 or 4.  A...
Need Help
Tips and Tricks
  • PhilipTreacy's avatar
    PhilipTreacy
    10 months ago

    Anonymous 

     

    Download example PBIX file

     

    Create a relationship between the tables on the ID column

     

     

    and set the Cross-filter direction to both

     

     

    Regards

     

    Phil

     

     

     

Anonymous's avatar
Anonymous
Not applicable
10 months ago

Works perfect, thanks!