Related Items with dynamic selection

[Nad_PBI_21]

Dear Everyone,

I'm currently attempting to perform and display an analysis on "related items." I have gone through several posts on this topic, but none of them truly address what I'm trying to accomplish, and I haven't been able to adapt the proposed solutions.

Here's what I'm aiming for:

I want to have a matrix or table that ranks articles sold by value or volume. When I click on an article in Table 1 or select multiple articles, I want Table 2 to display the related articles.

Related articles = All articles booked by Related Customers

Related customers = All customers having booked the selected article(s)

I tried using CalculateTable, but I couldn't achieve "dynamic" filtering based on the selection in Table 2. I also explored the idea of writing a measure within a measure, but I didn't succeed in implementing it. I attempted to adapt a solution I found, but it didn't work either (https://community.fabric.microsoft.com/t5/Desktop/Selection-of-related-items/m-p/603959)

I'm unsure if I'm approaching this problem correctly, so any assistance would be greatly appreciated.

Thank you,

Nad

Link to PBI file here: https://www.dropbox.com/s/t890i4x2f30fiwi/Articles%20Analysis%20-%20test%20-%20simple.pbix?dl=0

[amitchandak · Accepted solution]

@Nad_PBI_21 , The tables you have provided, do not have customer table or not clear with name

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Nad_PBI_21]

Dear amitchandak,

sorry my mistake,  I should have put the original name in german or the translation

I just changed german naming to english one in the file on dropbox,

thank you very much for your help

[amitchandak]

@Nad_PBI_21 , The link is not working now. Please provide updated link

[Nad_PBI_21]

https://www.dropbox.com/s/ns9nh7x6phmi1rw/Articles%20Analysis%20-%20test%20-%20simple.pbix?dl=0