View all Projects of selected Employees

[hendrikhendriks]

Update: I've added a simplified PBIX file via WeTransfer. Hope this clears things up. 

https://we.tl/t-npyo6OP1FP

The first page of my report gives an overview of a the employees that worked on a selected project (e.g. worked hours, start date)

Now, let's say I've selected project A. On the second page of my report I want to show all information of the employees that worked on project A. That is, the hours they worked on project A, but also other projects the initial selection of employees worked at. 

See Table below for basic idea of the two pages.

I don't think I can do this with a drill-though, so I am looking for a DAX formula, but can't seem to figure it out.

Please help

Page 1				Page 2
Project	Employee	WorkedHours		Employee	Project	WorkedHours
A	1	10		1	A	10
A	2	10		1	A	10
A	3	9		1	A	9
				2	B	4
				2	C	3
				2	D	5
				3	E	4
				3	E	4
				3	E	4

[hendrikhendriks · Accepted solution]

For anyone having the same issue. This article did the trick

Solved: Show all resources under selected projects + other... - Microsoft Fabric Community

[hendrikhendriks]

@some_bih I've added a sample PBIX file via the WeTransfer link. Could you please give it another shot? 
I think the description in the file is a lot more clear.

Would be really appreciated!

LINK:

https://we.tl/t-npyo6OP1FP

[some_bih]

Hi @hendrikhendriks I will check it the next few days, and provide feedback. Honestly, it is too warm to work these days 🙂 I hope you understand.

[hendrikhendriks]

@some_bih Haha no worries! Thank you so much man!

Appreciated!

[some_bih]

Hi @hendrikhendriks honestly it is hard to imagine what you describe. Nevertheless, did you try 2 slicer, one for project second for employees? Clear one for all when you show second one details. What you think?

[some_bih]

Hi @hendrikhendriks do you have only one table or two and more? In DAX there are table functions which could create tables, like SUMMARIZE and so. Please share your model with relationships and screen s. for details

[hendrikhendriks]

Hi @some_bih the model is in Dutch so won't make much sense to you. But it contains 1 Fact Table with the amount of worked hours. Both the project and employee Dimension Table are linked to the fact with a n:1 relation in both directions. Hope this helps!

[hendrikhendriks]

Hi @some_bih thank you for you involvement! 

I don't really get what you mean with "Clear one for all when you show second one details".

As soon as I clear one slicer (e.g. project) all the employees will be selected in my slicer and vice versa.

[some_bih]

Hi @hendrikhendriks did you try slicer visual?

[hendrikhendriks]

@some_bih Yes, but when I set my Slicer on Project A, the employee's other projects won't show. Setting the on the employees by hand would take too much time, since there can be quite a lot.