Changing slicer logic to AND

Hi pboron,

kudos for a perfectly formulated post, with screen shots, pbix-file and well described desired outcome.

I think you can solve this by creating a measure which is equal to 1 for the IDs in 'Table' which corresponds to the selected values in the slicer with AND-logic. First delete the relationship between Table2 and Table3. Then create this measure:

Filter Measure =
IF (
    ISFILTERED ( Table3[Criteria] );
    COUNTROWS (
        FILTER (
            ADDCOLUMNS (
                VALUES ( Table2[ID] );
                "numberOfConcurrentCriterias"; COUNTROWS (
                    CALCULATETABLE ( FILTER ( Table2; [Criteria] IN VALUES ( Table3[Criteria] ) ) )
                )
            );
            [numberOfConcurrentCriterias] = DISTINCTCOUNT ( Table3[Criteria] )
        )
    );
    1
)

Then add this measure to the Filter pane of your visual and set the value to be equal to 1. Example pbix

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.