21 Day Rolling - Measure is giving me broken line in my graph

[Invesco]

Hi Experts

when i select mulitple Activitys over a period i get broken line in my line graph - which are show 21 days rolling trends...

Measure

3 Week Rolling Trend = DIVIDE( CALCULATE(

COUNT('dev_rates_activity_volume_and_cf_days'[activity_type_2]),

DATESINPERIOD('dev_rates_activity_volume_and_cf_days'[Date],LASTDATE('dev_rates_activity_volume_and_cf_days'[Date]),-21,DAY)

) ,21)

Not sure how to resolve this....

[Invesco]

Ibendlin - thanks for the feedback...

[lbendlin · Accepted solution]

You should calculate this over your calendar table, not your fact table.  Please show your data model and/or provide sample data.