Forum Discussion

franorio's avatar
franorio
Helper III
9 years ago
Solved

Relationship problem, USERELATIONSHIP not working

Have two relationships, the active between my DimAreas and Area Anterior, and an inactive one between DimAreas and Sumar CF a...

 

 

This formula works great for me, I'm able to count Sumar CF a Column but my data gets related to my active relationship between DimArea and Area Anterior. 

COUNT of sumar cf = CALCULATE(
COUNTROWS('MovementsReport') ,
FILTER(
'MovementsReport',
NOT ISBLANK('MovementsReport'[Sumar CF a])
)
)

 

I need to apply this same formula but for my Inactive relationship for Sumar Cf a, when using USERELATIONSHIP i'm getting the next error

 

COUNT NEW AREA =
CALCULATE (
[COUNT of sumar cf],
USERELATIONSHIP ( DimAreas[Área], MovementsReport[Sumar CF a] )
)

 

*The USERELATIONSHIP function can only use the two column references that are involved in the relationship.

 

Any Ideas??

Thanks & Regards

Need Help
  • franorio's avatar
    franorio
    9 years ago

    User Vvelarde help me solved it!! Many thanks to him!

    Had a hidden table with the almost same name with a ´ difference, was writting in the formula the unrelated table. 

     

    I feel like an idiot!

     

    Thanks all for your time!

     

    Regards

3 Replies

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

    Hi franorio,

     

    Based on my test, the formulas you provided above should work in your scenario.

     

    Could you share a sample pbix file which can reproduce this issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards