Forum Discussion

NILU090's avatar
NILU090
Helper II
3 years ago
Solved

Inactive relationship chart filter

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 s...
Need Help
  • JorgePinho's avatar
    JorgePinho
    3 years ago

    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 🙂

JorgePinho's avatar
JorgePinho
Solution Sage
3 years ago

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 🙂