How to identify invoices with a specific product_ID?

[Maahmohammed]

How to identify invoices that has a specific product as per the below example?

I'd like to identify invoices including product A, The answer will be invoices No. 1 & 2 

How to solve that?

[parry2k]

@Maahmohammed your requirement is still not clear, please provide more context and few more examples.

[Anonymous]

Hi @Maahmohammed and Parry2k,

After reviewing the requirements, I think Maahmohammed needs a slicer to filter the product IDs. For example, if product ID A is selected in the slicer, invoices No. 1 & 2  will be displayed in the visual.

For example:

Slicers in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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

[Maahmohammed]

t if i want to select the invoices that doesn't include this product, all of the invoices will be listed.

e.g. As per my example & based on your solution, if i unselect "A", all invoices will be listed & that's wrng.

I need once the invoice incl;ude "A", the invoice itself marked with a special mark to be able filtering on the invoice level.

Hoping taht i illustrate the question well.

Regards

[parry2k]

@Maahmohammed what is the logic that you are looking for product a? Is this going to be dynamic or it is always fixed for product a?