Inactive relationship chart filter

[NILU090]

Hi Team,

i have following data modelling. Both relationships are INACTIVE.

I want to show output chart as per completed date.

also i have added filter of year. so everything should filter as per selected year.

please help me on this.

[JorgePinho · Accepted solution]

1st - Create a measure somethin like this: Amount_CompleteDate = CALCULATE(SUM(fact[amount]), USERELATIONSHIP(fact[Completed Date], TblDate[Date]))

2nd - Create a Bar Chart and use Date on the X-Axis and the measure on the Y-Axis.

Hope it works 🙂