Forum Discussion
Problems with slicer filtering both directions
Hi Anonymous ,
As shown in your screenshot ,since you already have a relationship between Region &Business and Global Sales,which will make ambiguity if you create another relationship between Region &Business and Region,try to create a measure instead using "USERELATIONSHIP" function,see below for reference:
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Community SupportHi Anonymous ,
Yes,I believe so,as you can see,the direction between Region and Region & Business is single,which means the table Region can filter the data in Region &Business,this will make filter table lose the filter function.
Modify the direction to both and test again.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thanks, Kelly. I already tried, but the model does not allow me to do so. I get following error message below. Probably since it's a one too many relationship.
Any smart tips on how to get around this?
- v-kelly-msft
Hi Anonymous ,
As shown in your screenshot ,since you already have a relationship between Region &Business and Global Sales,which will make ambiguity if you create another relationship between Region &Business and Region,try to create a measure instead using "USERELATIONSHIP" function,see below for reference:
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Best Regards,
KellyDid I answer your question? Mark my post as a solution!