Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help to resolve inactive relationship.

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 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , 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

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , 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