USERELATIONSHIP (How To?)

[Anonymous]

Hi Everyone,

I currently have a problem wherein I dont know how I'll be able to use my date slicer, in order for me to slice customers enrolled using my date table. Currently I am using a 'Reporting Week' Column built in to the transaction table. The current relationships look like this:

Visual in Case:

When I create a relationship between 'Paperless Enrolled' and 'Date Table' , I get an ambiguous relationship

What can I do in order for me to be able to use the date table to slice my visual using the date table instead of the dates inside the transactional table? Thanks!

[Anonymous]

Hi @pratyashasamal , upon using the USERELATIONSHIP, it returns me a total of 539 every month,

here's the dax for the current measure which I used from the SQLBI Guide. I'm not entirely sure what's missing.

Ideally it should return something like this:

Appreciate your help!

[pratyashasamal]

Hi @Anonymous ,
Can you send over the sample dataset or sample pbix file so that i could understand what is causing the issue .
Thanks ,
Pratyasha

[pratyashasamal]

Hi @Anonymous ,
There is a guide to Userelationship function in Power Bi :
https://www.sqlbi.com/articles/using-userelationship-in-dax/

Thanks ,
Pratyasha

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C