Forum Discussion
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...
Hi, thanks for that, I tried that but it makes all the numbers disappear.
Do you have some sample data, or a cut down version of your PBIX file?
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.
Hi eburke
It should work if you change the direction of your relationship.
I've uploaded a simple PBIX file to show an example.