topic Re: View all Projects of selected Employees in DAX Commands and Tips

View all Projects of selected Employees

hendrikhendriks — Wed, 12 Jul 2023 11:56:58 GMT

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

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

Re: View all Projects of selected Employees

some_bih — Thu, 29 Jun 2023 12:46:43 GMT

Hi hendrikhendriks did you try slicer visual?

Re: View all Projects of selected Employees

hendrikhendriks — Thu, 29 Jun 2023 12:56:07 GMT

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.

Re: View all Projects of selected Employees

some_bih — Thu, 29 Jun 2023 13:01:20 GMT

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?

Re: View all Projects of selected Employees

hendrikhendriks — Thu, 29 Jun 2023 13:30:37 GMT

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.

Re: View all Projects of selected Employees

some_bih — Thu, 29 Jun 2023 14:25:11 GMT

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

Re: View all Projects of selected Employees

hendrikhendriks — Tue, 04 Jul 2023 07:23:44 GMT

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!

Re: View all Projects of selected Employees

hendrikhendriks — Wed, 12 Jul 2023 11:59:11 GMT

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

Re: View all Projects of selected Employees

some_bih — Thu, 13 Jul 2023 05:15:33 GMT

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.

Re: View all Projects of selected Employees

hendrikhendriks — Thu, 13 Jul 2023 06:56:07 GMT

some_bih Haha no worries! Thank you so much man!

Appreciated!

Re: View all Projects of selected Employees

hendrikhendriks — Mon, 17 Jul 2023 13:48:45 GMT

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

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