Using Dates for specific customers

[Syk]

Hello! I currently have this measure..

measure = CALCULATE([Digital Sales %],  DATESBETWEEN('Accounting Date'[Dates],MIN('Accounting Date'[Dates]),MAX(Issues[Go Live Date])))

I have chart to look at this measure and noticed that even though each customer has a particular go live date, it is always getting the latest date. (for every customer it uses customer A's date since its the latest)

How can I force my measure to look at the go live date that corresponds to the customer? Relationship between go live and customer below joined on a customer key.

[tamerj1]

Hi @Syk 

I suppose you are slicing by "Customers" from 'Ship to Cutomer' table. If the Customer name is not available in the issues table you can add it to table visual as a measure

Go-Live Date =
CALCULATE (
    SELECTEDVALUE ( Issues[Go Live Date] ),
    CROSSFILTER ( 'Ship to Customer'[Customer Key], Issues[Customer Key], BOTH )
)

[Syk]

While this works for a table, it throws memory errors when I try to use it in my charts.

[tamerj1]

Can you please share a smaple file?