USERELATIONSHIP issues between desktop and service

[BaptisteRodet]

Hi everyone, 

I am struggling with an issues using the function USERELATIONSHIP.
My example is pretty easy to understand : 
I have a table that is related with several dates to my calendar, intervention date and closure date. Both are disabled by default. 
I have two measures :
count_establishment_with_intervention, 

CALCULATE(

    DISTINCTCOUNT('establishments[establishment ID]),

    USERELATIONSHIP('establishment_monitoring'[closure date], 'calendar'[date])

)

count_establishment_with_closure 

CALCULATE(

    DISTINCTCOUNT('establishments[establishment ID]),

    USERELATIONSHIP('establishment_monitoring'[intervention date], 'calendar'[date])

)

Both measures are working in the desktop showing respectively 400 establishment interventions and 100 establishment closures. But in the service I now only have 90 interventions and 90 closures. There's less than 80 closures with interventions. I dont understand the gap between the desktop and the service. 

I've seen that USERELATIONSHIP doesn't work with RLS but I dont use RLS. 

If someone knows whats happening between the desktop and the service for USERELATIONSHIP measures please enlighten me. 
Thank you 

[FedeMosquera]

Hi everybody,

What we did in my company with a report was to use TREATAS instead. There were about 40 measures that needed to be changed from USERELATIONSHIP to TREATAS, for which I used Microsoft Copilot with the following prompt "I'm going to give you DAX measures that have the USERELATIONSHIP and I want you to give back the same DAX measure but using TREATAS instead".

I also erased all the inactive relationships I had between the Dimension table with the RLS and the fact tables, as they are not needed using TREATAS.

We couldn't wait for Microsoft to correct this, so this method worked for us. Hope this helps.

Regards

Federico

[v-sgandrathi · Accepted solution]

Hi @BaptisteRodet,

Hope you are doing well
Thanks for connecting with the Microsoft Fabric Community Forum.

Thank you @Idrissshatila for identifying the issue on the thread.

The product team will address and resolve this issue as soon as possible.
Please keep track of it so you will be notified once it is resolved.

If this post clears your doubt, please give us Kudos and consider marking Accepting it as a solution to guide other members in finding it more easily.

Thank you have a great day a head.

[Idrissshatila]

Hello @BaptisteRodet ,

there's an issue submitted regarding the issue you're facing, check it out
https://community.fabric.microsoft.com/t5/Issues/Bug-report/idc-p/4378048#M110813