How do I have the Filter Object in "and" on the dashboard?

[Syndicate_Admin]

Hello to tod ,

I need your help.

I have a table with customers and attractions, wanting to know that customers have subjected the attraction not to it. In this way cross selling of attractions that have not been suddenly made.

On the dashboard I had a filter type object which when I selected more than one attraction would give me the result as "OR" and I wanted it to be as "AND".

Customer Attraction

Cl1	Worm
Cl2	Zip line
Cl2	Devil
Cl1	Devil
Cl3	Devil
Cl3	Worm
Cl2	Worm
Cl3	Zip line
Cl4	Worm

Thank you!!

[V-lianl-msft · Accepted solution]

Hi ,

Try to create the following measure and apply it to the corresponding visual level filter.

Measure = 
var count_att=
    CALCULATE(COUNT('Table'[Customer]),
        FILTER(ALLSELECTED('Table'),
            COUNTROWS(
                FILTER('Table',
                    EARLIER('Table'[Customer])='Table'[Customer])
                    )
                )
            )
var count_selected = 
    CALCULATE(
        DISTINCTCOUNT('Table'[Attraction]),
        ALLSELECTED('Table')
        )
return IF(count_selected=count_att,1,0)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

Hello

I want to use the object "data segmentation" and that works with an "and" and not with an "or". When you have two options selected from the object, the result is reflected in the table I have created.

Thank you!

[lbendlin]

You need a detached table for the attractions slicer.  Then use VALUES() for the customer attractions and compare it via INTERSECT()  to the FILTERS() of the detached table.  If the tables match then the customer has attended all selected transactions.   Or you can identify which of the selected attractions the customer has not visited by using EXCEPT()

[Syndicate_Admin]

Hello

I created the table, but the rest of the functions I have never used them, can you give an example?
Thank you!!