need max in measure (for AND condition for slicer)

[Pikachu-Power]

Hello Power BI users,

I have two tables customer and sales which are connected in both directions. The column color from the sales table i use as a slicer.

Then i wrote following measure:

customer_AND-Only =

VAR countRowsSales =

COUNTROWS(

    DISTINCT(

        SELECTCOLUMNS(Sales, "Color", Sales[Color])

        )

    )

RETURN

countRowsSales

When i put this measure in the customer table and choose for example Black and Red in the slicer i see 1 or 2 for the customers. What i want is something like

IF(countRowsSales = MAX(countRowsSales), "OR, AND", "OR")

Or if countRowsSales would return the MAX or BLANK it would be also suffcient. That would be easy to integrate in the if condition.

Someone an idea?

(I need this to switch the slicer later between AND and OR condition)

Many thanks!

[Greg_Deckler]

@Pikachu-Power Slicers by default are OR condition. Here is an example of creating an AND condition for a slicer: Patient Cohort (AND Slicer) - Microsoft Power BI Community

[Pikachu-Power]

Hi Greg,

I used this way:

Slicer with AND condition in Power BI - RADACAD

I tested your example but the way from RADACAD looks more suitable for my case because i have some tables. Would be nice if i can just put the measure in the filter pane at the end.

But in my case i have just two tables instead of three tables like in RADACAD. That changes a little bit the situation 😕

[Pikachu-Power]

PS: 

My idea with:

IF(countRowsSales = MAX(countRowsSales), "OR, AND", "OR")

was wrong. Because if i choose 3 colors MAX can be 2.

To make it more easy / understandable:

If we only refer to the RADACAD example. I think i found out my mistake: DimProduct[color] have to be outside from FactInternetSales. Otherwise the measure "Purchased Products with AND-Only Condition" doesnt work because DimCustomer would filter countRowsProducts.

But if we have no DimProduct table and the column color would be in the table FactInternetSales. How do we have adjust the measure "Purchased Products with AND-Only Condition" then? That is the case i described above. And DimCustomer and FactInternetSales are connected in both directions in my case.