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, 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