Relationship problem, USERELATIONSHIP not working

[franorio]

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

[v-ljerr-msft]

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. 

Regards

[franorio]

Hi @v-ljerr-msft thanks for your time, 

here you will find the report, 

https://www.dropbox.com/sh/idkvgmk4siy1ml7/AADQczWdxUhY9D_vQKfWOoAWa?dl=0

Thanks again. 

Best Regards!

[franorio · Accepted solution]

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