Forum Discussion
Indirect relationship reporting
Hi,
Can anyone suggest how I can achieve the following?
My data looks something like this:
Processes-Services Table
Process | Service |
A | 1 |
B | 2 |
C | 1 |
Service-Service Table
Source Service | Target Service |
1 | 2 |
2 | 3 |
2 | 4 |
I would like power BI to report back the following when I select service 1 as a filter / slicer:
Processes Impacted Directly
Process A
Process C
Processes Impacted Directly
<None>
Services Impacted Directly
2
Services Impacted Indirectly
Service 3 (via service 2)
Service 4 (via service 2)
As another example, I would like power BI to report back the following when I select service 2 as a filter / slicer:
Processes Impacted directly
Process B
Processes Impacted Indirectly
Process A (via Service 1)
Process C (via Service 1)
Services Impacted directly
Service 3
Service 4
Services Impacted indirectly
Service 1 (via service 2)
I think I need to set up a "query within query" to use the results of the 1st query in the 2nd query.
Can anyone recommend a way of doing this? Can this be achieved by adjusting the data model or is this more complex?
1 Reply
Hi ianf123 ,
I don't understand clearly about your requirement. How do you want to display the results, in one table or others? You could get the most output by filter with slicer.
Can you share more details? What the effect do you want? And I attached my sample that you can point at the difference between it and yours.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
