Customers who bought a SPECIFIC product only

[JNYY]

Hi all,

We are trying to build a report to identify customers who bought a specific product only, and not other products. 

Tyring to adapt the solution from a similar thread to our context but we kept hitting into error. Appreciate if anyone can help.

https://community.powerbi.com/t5/Desktop/Customers-who-have-NOT-bought-a-product/td-p/199670

Measure =
IF (
    HASONEVALUE ( Items[Item] ),
    CALCULATE (
        SUM ( Sales[Sales] ),
        FILTER (
            Sales,
            NOT ( CONTAINS ( Sales, Sales[Item], VALUES ( Items[Item] ) ) )
        )
    ),
    SUM ( Sales[Sales] )
)

[Ashish_Mathur]

Hi,

Share your data and also show the expected result there.

[JNYY]

Hi,

My objective is to create a dynamic measure which returns the sales for customers who bought, say BABYBOY only.

Expected result from this snapshot: Return only CustomerNo = 23542 with Sales = 101.03

Thank you very much in advance!

[Ashish_Mathur]

Hi,

Thank you for clarifying.  Please share a sample dataset to work with.