Forum Discussion

inescosta's avatar
inescosta
Advocate II
9 years ago

slicer distant relationship

Hello,

 

I have a measure that is summing up values in table PROJETOSEGMENTO, and I want to use a slicer so that my measures sums by department.

 

But the relationship between the two tables isn't direct at all.

 

Can somesone help me ? can I use userelationship is some way??

 

Thank you,

 

Ines

 

I

 

Need Help

4 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    inescosta

     

    If you want to use a slicer which can slice the PROJETOSEGMENTO measure with Department, you must have active relationship between these tables. It must have a path from Department to PROJETOSEGMENTO.

     

    If you just need to slice the measure in DAX, you can use USERELATIONSHIP() to use inactive relationship for your calculation.

     

    Regards,

     

     

    • inescosta's avatar
      inescosta
      Advocate II
      9 years ago

      Yes, I am using a DAX expression, my problem with USERELATIONSHIP is that I have a series of relationships I need it to consider, so should I use:

      USERELATIONSHIP(Department[code];Servprod[codigodepartament];servprod[id];tipoprojeto[servprod_id])

USERELATIONSHIP(Department[code];Servprod[codigodepartament]); USERELATIONSHIP(;servprod[id];tipoprojeto[servprod_id])

ETC....
      • v-sihou-msft's avatar
        v-sihou-msft
        Microsoft Employee
        9 years ago

        inescosta

         

        You can only specify two columns to use the inactive relationship between them.

         

        Regards,