How to list who are the customer buying Brand A and Brand B ?

[Paulyeo11]

Hi All

it there a simple approach to create a expression to filter customer who buy below 2 Brand ?

For example if user select GE and REDLION from Slicer , it will list the customer name that buying these 2 brand.

My PBI file :-

https://www.dropbox.com/s/ftug7f0fsa9fyqu/PBT_V01015%20Buy%20Brand%20A%20and%20B.pbix?dl=0

Paul

Paul Yeo

[AlB · Accepted solution]

Hi @Paulyeo11 

1. Place SALES[COMPANY] in a table visual

2.  Create this measure:

ShowMeasure = 
VAR numSelected_ = DISTINCTCOUNT( SALES[BRAND] )
VAR res_ =  IF (
        COUNTROWS ( FILTER ( DISTINCT ( SALES[BRAND] ), [SALES_] > 0 ) ) = numSelected_,
        1,
        0
    )
RETURN
res_

 3.  Place [ShowMeasure] as a visual filter and choose to show when value is 1

 4. See it all at work in the attached file (BRAND page)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB · Accepted solution]

@Paulyeo11 

See it all at work in the attached file (page BRAND 2). Note you must not make a selection in the slicer in this case.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

See if my solution here helps - Identify Customers that Organisations can upsell or cross sell their products to.

[Paulyeo11]

Hi Ash

thank you very much for sharing the link , that is what I am looking for

[AlB · Accepted solution]

@Paulyeo11 

See it all at work in the attached file (page BRAND 2). Note you must not make a selection in the slicer in this case.

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB]

@Paulyeo11 

You can follow the same pattern and create another measure that will be used as filter visual.

ShowMeasure 2 =
VAR numSelected_ =
    DISTINCTCOUNT ( SALES[BRAND] )
VAR res_ =
    IF (
        CALCULATE ( [SALES_], SALES[BRAND] = "BECKHOFF" ) > 0
            && CALCULATE ( [SALES_], SALES[BRAND] = "MOXA" ) = 0,
        1,
        0
    )
RETURN
    res_

 Although this is not very flexible. You might want to do it with slicers so that you can choose the brands in the slicers rather than hard-code them

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlB · Accepted solution]

Hi @Paulyeo11 

1. Place SALES[COMPANY] in a table visual

2.  Create this measure:

ShowMeasure = 
VAR numSelected_ = DISTINCTCOUNT( SALES[BRAND] )
VAR res_ =  IF (
        COUNTROWS ( FILTER ( DISTINCT ( SALES[BRAND] ), [SALES_] > 0 ) ) = numSelected_,
        1,
        0
    )
RETURN
res_

 3.  Place [ShowMeasure] as a visual filter and choose to show when value is 1

 4. See it all at work in the attached file (BRAND page)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Paulyeo11]

Hi AIB

Appreciated very much for your sharing , can you advise me how to filter those customer Buy Beckhoff and not buy MOXA ?

[amitchandak]

@Paulyeo11 , Please find the file attached after the signature. Check for measure All