Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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, 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 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
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