best choice when buying

[Daniff]

Good afternoon friends, I need your help here in a table relationship exercise.

In general, I need to select a seller and, according to what I bought, appear in the same table, all the options available in my warehouses within the group in which that same product is inserted.

Let's look at the case in the image.

 

Seller A,

I choose the month 2023-02-01 to see the sales of that seller in that month,

I select the type of products BB (this filter will filter the products that belong to this category that I sold and in the same table all the options must appear available for purchase at the warehouse for this seller A.

That is, for each sale, I want all the options available at the warehouses to appear for each product sold. Can you help me how to make this table? by dax please because by query as the sales database is big it is very slow! I enclose the power bi project.

Very grateful for your help!

project power bi - https://we.tl/t-BgF4uOElnU

[v-shex-msft · Accepted solution]

Hi @Daniff,

It sounds like you want to achieve custom filter effect instead directly filter table records based on relationship.

For this scenario, I'd like to suggest you to use an unconnected table as source of slicer, then you can write measure formula to extract the current selection from filter and compare with table row context to return flag.

After these steps, you can use this formula on second table 'visual level filter' to filter and show the correspond records.

Display Flag =
VAR selection =
    VALUES ( NewTable[Seller] )
VAR currSeller =
    SELECTEDVALUE ( Table[Seller] )
RETURN
    IF ( currSeller IN selection, "Y", "N" )

Regards,

Xiaoxin Sheng