Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 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
    11 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

     

     

     

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
11 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

 

 

 

raji_n's avatar
raji_n
Icon for Resolver II rankResolver II
11 months ago

This is helpful. Thanks.