Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data Model - switch relation from inactive to active by condition.

Hi All, I need your help in switch relation from inactive to active by condition.   I have 4 tables. tabe 1: table 2: table 3: filter: Data Model:   dashboar...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

In this case I just simplified my tables.
In reality I've 2 fact tables contain 500K Rows Each and I want to add filter which filter both.

 

Thank you Greg for your kindness

 

Idan

 

 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may set the relationships as inactive. Then create the measures with USERELATIONSHIP Function. For example:

Index1 = CALCULATE(SUM(Table1[index]),USERELATIONSHIP(Table1[index],'filter'[index]))
Index2 = CALCULATE(SUM(Table2[index]),USERELATIONSHIP('filter'[index],Table2[index]))

Attached the sample file for your reference. Below are some articles for you. Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

https://www.kasperonbi.com/dynamic-data-comparisons-using-disconnected-slicers-treatas-and-inactive-relationships/

http://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

 

Regards,

Cherie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Cherie,
    Tks for your quick respond :)

    The solution not solved all the issue.
    When I am choosing filter category from filter Table then Table 3 not respond.

     

    Idan

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Cherie,
        I tried to apply this method on real data and it doesn't work.

        I upload my real data file contain only relevant information.

        Pls take as show in real data sheet - link

         

        Hope for your respond.

         

        Tks,
        Idan