I've got a classic "fact" table with Membership data linked to a "date" dimension table.  The fact table stores membership data at each month end date.  My Members Added measure works as expected, but Members Added YTD repeats for every date in the Dim_Date table.  I wasn't expecting that.  I only want to show the dates for which there is data.

Members Added:  =CALCULATE(SUM(Fact_MemberWalk[MemberCount]),Fact_MemberWalk[TranType]="New Member")

Members Added YTD: CALCULATE([Members Added],DATESYTD(Dim_Date[DateKey]))

Picture of Problem:

Hi Kirk,

According to your description, this issue is more related to Power Pivot. The Power Pivot forum is a better place for Power Pivot issue, we will move it there for you.

Regards

Starain

Kirk, are you still trying to get this figured out?

Thanks!