Need Help to resolve inactive relationship.

[adeeln]

I have two dates in Fact table One is "Closeddate" and second date is "newAccountDate".I have  created Date dimension table on the based of closed date .I have Active Relationship between "Closed date" from Fact table and "Date" from dimension date table.

The reason behind to created Active realtionship with closed date because some measures worked on the based of Closed date.

For only one measure i need realtionship with "newAccountDate" but this is not work . When i use "newAccountDate" from fact table its work .But i am use Date(month,year,monthyear) from Date table this date is not work. i have used following measure.

Nb Of New Accounts =

var minSelectedDate = MIN(DimDate[Date])

return

CALCULATE(

DISTINCTCOUNT(Opportunity[AccountKey]),

FILTER(Opportunity,

[newAccountDate] >= minSelectedDate

)

,USERELATIONSHIP(Opportunity[newAccountDate],DimDate[Date]))

Pbix file link is given below
https://www.dropbox.com/s/z80yp4zpjmnzsxm/Trends%20Analysis.pbix?dl=0 

[amitchandak · Accepted solution]

@adeeln , Create measure like

Nb Of New Accounts = 


var  minSelectedDate = minx(ALLSELECTED(DimDate), DimDate[Date])
return //minSelectedDate
CALCULATE(
    DISTINCTCOUNT(Opportunity[AccountKey]), 
    FILTER(DimDate,
    DimDate[Date]>= minSelectedDate
    ),USERELATIONSHIP(Opportunity[newAccountDate],DimDate[Date]))

also check I doubt dates are missing for newaccountdate