Forum Discussion

rakesh-k01's avatar
rakesh-k01
Frequent Visitor
9 years ago
Solved

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 us...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

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's avatar
rakesh-k01
Frequent Visitor
9 years ago

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