Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Data selection

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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