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
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.

       

      • eburke's avatar
        eburke
        Helper II
        8 years ago

        Hi Phil,

         

        Thanks for the offer, unfortunately this file has been sent to me from another source in the company and I can't access some of the data tables to be able to delete sensitive information so won't be able to send you a cut down version.  I appreciate your help, I might have to explore other options, hopefully someone in my company can help.