List of customer who bought ALL selected columns

[thefunnyenterta]

Hello! 
With the help of a slicer (or/and a filter), I would like to have the list of customers who are in different columns. For example, If in a slicer I select the major 2 - Bieber and the minor SHADE, I would like to have the list of customers who bought both of those categories (AND logic instead of OR logic). In this case, the list of clients would only consist of customer A. Thank you. 

I put a power bi file as an example. 

help 

[smpa01]

@thefunnyenterta  with the current structure, I don't think you can utilize the slicer from the same table.

I solved it by utilizing a disconnected slicer table for major and minor

__major+minor = 
VAR major =
    SUMMARIZE (
        FILTER ( 'Table', ( 'Table'[Major] ) IN ( VALUES ( slicerMajor[Major] ) ) ),
        'Table'[Customers]
    )
// VAR debuggerOne =
//     TOCSV ( major, -1, "," )
VAR minor =
    SUMMARIZE (
        FILTER ( 'Table', ( 'Table'[Minor] ) IN ( VALUES ( slicerMinor[Minor] ) ) ),
        'Table'[Customers]
    )
// VAR debuggerTwo =
//     TOCSV ( minor, -1, "," )
VAR inner =
    UNION ( major, minor )
// VAR debuggerThree =
//     TOCSV ( inner, -1, "," )
VAR val =
    MAXX ( inner, [Customers] )
RETURN
    val

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[CNENFRNL · Accepted solution]

[Greg_Deckler]

@thefunnyenterta Patient Cohort (AND Slicer) - Microsoft Power BI Community

[thefunnyenterta]

@Greg_Deckler Thank you for the quick reply. However, in my case the categories are in multiple columns as you can see in my explanation. Maybe I'm not clear enough. Will the solution you provided work in my scenario ? Thanks !

[Greg_Deckler]

@thefunnyenterta Would take some tweaking. Can you post your sample data as text and maybe an example of the expected output given some selections?