Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Edit Interactions - cross filtering on visuals

I have various filters that I'm using so that columns appear dynamically in the matrix.   Those three filters are from the same field.  Versus having a long list of options I was trying to break it u...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jcastr02 ,

     

    Try creating this field as a separate dimension table and splitting it into three fields. Get the slicer value via selectvalue and then use if(max([field])=_s1||max([field])=_s2||max([field])=_s3,1,0), to set this measure value to 1 in the filter.

     

    Please feel free to correct me and provide more information if I have misunderstood you!

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jcastr02 ,

 

Try creating this field as a separate dimension table and splitting it into three fields. Get the slicer value via selectvalue and then use if(max([field])=_s1||max([field])=_s2||max([field])=_s3,1,0), to set this measure value to 1 in the filter.

 

Please feel free to correct me and provide more information if I have misunderstood you!

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.