Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

USERELATIONSHIP issue

Hello Community  -  I'm confused as to why I am not seeing the results I expected.     I have a dim date table and a salesforce opportunity table.   I have an active relationship between close date...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    I think the problem is that the FILTER argument is being calculated before the REMOVEFILTERS is applied, so the only rows which will be visible are the ones which match the date using the active relationship.

    Try

    Value of Open Opportunities =
CALCULATE (
    [Sum of Tech Amount Converted],
    USERELATIONSHIP ( Sf_Opportunity[Customer_Requested_Ship_Date__c], 'Dim_Date Table'[Date] ),
    Sf_Opportunity[Status__c] = "Open"
)
johnt75's avatar
johnt75
Super User
3 years ago

I think the problem is that the FILTER argument is being calculated before the REMOVEFILTERS is applied, so the only rows which will be visible are the ones which match the date using the active relationship.

Try

Value of Open Opportunities =
CALCULATE (
    [Sum of Tech Amount Converted],
    USERELATIONSHIP ( Sf_Opportunity[Customer_Requested_Ship_Date__c], 'Dim_Date Table'[Date] ),
    Sf_Opportunity[Status__c] = "Open"
)
Anonymous's avatar
Anonymous
Not applicable
3 years ago

johnt75    Fantastic...that worked perfectly.  

I might add for those that see this post that the formula I orginally used was created by ChatGPT 3.5.   And even after telling it several times that I was not getting the correct results, and explaining the problem, it still was apparently not able to correct it.