List of Products sold to only one single Customer

[Trudgeon]

I'm trying to get a list of products that were sold to a single customer.  I can easily attain an accurate list of products with a COUNT function by Customer that is filtered to "1".  However, once I bring in customer detail, the list blows up.  Any advice?

[HotChilli]

Adding in the Customer changes the context.  The table now shows a count of products where a customer has bought one (per customer).

This is how measures work, they adapt to the context in which they are evaluated.

You have options: re-write the measure to alter the context back to the original

or (depending on your model) put the customer in a separate visualisation (rather than add it to the table) and click the rows of the table.

Post your pbix here if you want someone to look at it

[Trudgeon · Accepted solution]

This link solved my problem:

https://stackoverflow.com/questions/50414271/creating-a-measure-that-returns-distinct-count-by-count...

The function I used:

CUSTOMER_COUNT_BY_PRODUCT = 
    CALCULATE(DISTINCTCOUNT(VIEW_SALES[CUSTOMER_CODE_SOLD]),
        ALLEXCEPT(VIEW_SALES, VIEW_SALES[MFC_PRODUCT_CODE],VIEW_SALES[TRANSACTION_DATE]))