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 selected year.

please help me on this.

 

 

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 🙂

1 Reply

  • 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 🙂