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
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" )