How to use AND in slicer

[rakesh-k01]

This might be a bit hard to explain, so will update based on the info needed. 

Hi,

I have 2 tables having 1 to many relationship with the ref2per table. 

I' am using a slicer on ref_table to display the person table details in a matrix.

Below is the output of an example:

 Slicer is using OR to display the records having either SAP or EventBrite, but i need person records having both SAP and EventBrite. Below is the expected output.

Any thoughts on how this can be done?

Thanks

[Vvelarde · Accepted solution]

@rakesh-k01

hi, create a measure:

Show =
IF ( COUNTROWS ( VALUES ( Ref_Table[name] ) ) = COUNTROWS ( Ref2Per ), 1, 0 )

and in Visual Level Filter select when Show is 1.

Regards

Victor

Lima - Peru

[rakesh-k01]

@Vvelarde

Hi Victor,

Thanks again with the solution. But the measure seems to fails if I have multiple person having same name or if I have same combination of person_id and ref_source_system_id in ref2per table. Below are the two updated table.

Could you please help me with this. Thank you and appreciate your time.

Regards,

Rakesh

[rakesh-k01]

@Vvelarde

Hi, Thanks for the response. That actually worked! 

It did not work on my existing report not sure why but when I recreated the report from the scratch your solution worked. Thanks a ton. 

I have one single doubt though, can we have it as a slicer like an option of "AND" & "OR"?

Thanks 

Rakesh