Forum Discussion

eburke's avatar
eburke
Helper II
8 years ago

Help needed with filtering

Ok so I have a problem that I think means I've missed something really obvious and simple but I can't see what.  I have three tables:   Data table: Client Name, Employee ID, Task Name, Duration, D...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Do you have some sample data, or a cut down version of your PBIX file?

eburke's avatar
eburke
Helper II
8 years ago

Hi I can't post the PBIX file even in one drive our system doesn't allow us to share anything externally.  Here's an example of the data in the table though, the names have been removed for privacy.

 

Data table:

 

 

Staff Table:

 

\

 

Roles Table:

 

Relationship:

Thanks for your help.

    • eburke's avatar
      eburke
      Helper II
      8 years ago

      Hi Phil,

       

      Thanks for that, i can see how it works on your file.  I have set mine up exactly the same way but it still gives me a result with no numbers.

       

      I'm stumped on this one.

      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        8 years ago

        hI eburke

         

        You may have some data related issues that are causing it.  If you can find out a way to get a cut down version of the PBIX file to me I can dig deeper for you.

         

        Feel free to PM me and exchange email addresses if that helps.