Forum Discussion

DominikTher's avatar
DominikTher
Frequent Visitor
8 years ago
Solved

Join paths and relationship

Hello all, I have a simple model, with some relationships. If I don't restrict this in RLS everything works fine. But after that, I receive error message "Join paths ...". So the problem i think is i...
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi DominikTher,

     

    Based on my test with your shared pbix file, you should be able to use the formula below to create a new measure to indicate if the Data[CountryId] is in filtered Hub, then use it to apply a visual level filter(Measure 2 is 1) on the Table visual in your scenario.

    Measure 2 =
IF (
    CONTAINS ( HubCountry, HubCountry[CountryId], MAX ( Data[CountryId] ) ),
    1,
    0
)

     

    Here is the modified pbix file for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi DominikTher,

 

Based on my test with your shared pbix file, you should be able to use the formula below to create a new measure to indicate if the Data[CountryId] is in filtered Hub, then use it to apply a visual level filter(Measure 2 is 1) on the Table visual in your scenario.

Measure 2 =
IF (
    CONTAINS ( HubCountry, HubCountry[CountryId], MAX ( Data[CountryId] ) ),
    1,
    0
)

 

Here is the modified pbix file for your reference. :smileyhappy:

 

Regards

DominikTher's avatar
DominikTher
Frequent Visitor
8 years ago

Hello v-ljerr-msft, thanks for your solution.

 

Hope that someday i find solution how to get also prefiltred countries. Beacause we have lot of data and countries.

But right now your solution is very very helpful. And answer as is are acceptable :) 

 

Thank's

 

And if there will be solution for Countries i post it back.

 

Dominik

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    DominikTher I have got the same problem you had.  The soluation in the thread is good to filter tables. However, the country filter is not prefiilterd. Have you found a solution? Thanks!