Forum Discussion

WillT's avatar
WillT
Icon for Community Admin rankCommunity Admin
10 years ago

Customers who bought multiple products

Hi everyone. Worked on a little problem recently to try and figure out "customers who bought combinations of products". I have seen plenty of posts and great patterns on Basket Analysis (e.g. DAX Pat...
Show and Tell
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

Hi, In the PowerBI Sample you can't select more than 1 product.

 

EDIT: Sorry, Its correct.

 

 

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Vvelarde Not sure what you mean - you can CTRL select or just turn off single select (in the pbix file)

     

    EDIT: CTRL Select works on the published report

     

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      Here's the Measure for everyone to see!

       

      Buyers of All Selected Products =
IF (
    ISBLANK (
        COUNTROWS (
            FILTER (
                SUMMARIZE (
                    Sales,
                    Sales[Customer],
                    "ProductsBought", DISTINCTCOUNT ( Sales[Product] )
                ),
                [ProductsBought] = COUNTROWS ( VALUES ( Sales[Product] ) )
            )
        )
    ),
    0,
    COUNTROWS (
        FILTER (
            SUMMARIZE (
                Sales,
                Sales[Customer],
                "ProductsBought", DISTINCTCOUNT ( Sales[Product] )
            ),
            [ProductsBought] = COUNTROWS ( VALUES ( Sales[Product] ) )
        )
    )
)

       

      Thanks to WillT :smileyhappy:

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi,

        This Solution is working for me and going fantastic but can i show the name of customers who bought all products also?

        I am unable to show the customers name with this DAX.

        Please help

         

        Thank you!