help

[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-jianboli-msft · Accepted solution]

Hi @Daniff ,

Please try:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.