Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

USERELATIONSHIP issues between desktop and service

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 
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi Anonymous,

    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.

3 Replies

  • v-sgandrathi's avatar
    v-sgandrathi
    Community Support
    1 year ago

    Hi Anonymous,

    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.

  • FedeMosquera's avatar
    FedeMosquera
    Frequent Visitor
    1 year ago

    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