Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problems with slicer filtering both directions

Dear community,   I got a challenge with a filter table (Region & Business Unit) that I created - see picture below. The filter table is a merge of two separate tables: (Region) and (Business Unit)...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

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

    Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

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

Did I answer your question? Mark my post as a solution!