Data selection

[Syndicate_Admin]

Hello

I have a report where I have a table with the stock of all my products, and I want it if I filter an order; that's in another table, I just show the stock of the items that appear in that order.

Thank you

Nuria

[v-yiruan-msft]

Hi @Syndicate_Admin ,

Could you please provide some sample data in product table and table which include order info and expected result with examples just as suggested by @amitchandak ? Please also share the related relationship info(base field or cardinality etc.) if there is any relationship created between these two tables.

On the other hand, please review the info in the following thread and check whether it can help you get it.

Show all items in an order when one product is filtered

Best Regards

[amitchandak]

@Syndicate_Admin , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Based on what got try a measure like

sumx(filter(Table2, Table2[order] in values(Table1[order])), Table2[Value])