Forum Discussion
How to use AND in slicer
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
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
3 Replies
- Vvelarde
Community Champion
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
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
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
