Forum Discussion
Post PartisanPlease help! why the userelationship not working
Dear all,
I have two dimesion table(d_date and d_cases) both link to a fact table(f_call)
Now I want to use userelationship to build realtionship between my two dimesion tables. My goal is to use d_date as a slicer to filter the report, and count how many cases completion from cases table. But is gave error: USERELATIONSHIP function can only use the two columns references participating in relationship.
Below is my dax function:
6 Replies
- parry2k
Super User
xiumi_hou can you make sure you have relationship between d_cases[closed_date] with d_date[Date]
if you already have relationship between these two tables on other column, you still need to set relationship on closed_date which will be inactive.
There can be only one active relationship, but you can have more than one inactive relationships
hnguy71I believe the error is stating that you need either an active or inactive relationship that already has been set. Only then will you be able to use the USERELATIONSHIP function. What you want actually would be to use TREATAS
So in your example, something like this:
Count_Completed_Cases =CALCULATE(DISTINCTCOUNT(d_Cases[CaseNumber]),d_Cases[Closure_reason_c] = "Completed",TREATAS(VALUES(d_Cases[Closed_date_c]),d_date[Date]))- hnguy71
did you forget to close the parenthesis after VALUES?
