DAX - limiting DATEsYTD to entities present in the selected month

[gsw811]

I'm using DATESYTD to produce a YTD count of the number of Falls (eg FallYTD:=Calculate(SUM([Falls],DatesYTD(tablename[Date])) The issue I'm encountering is that I want the YYD metric calculated only on the entities that provide data for the selected month. For example
[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]10[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]15[/TD]
[TD]Jan
[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]20[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]25[/TD]
[TD]Jan[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]30[/TD]
[TD]Feb[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]C[/TD]
[TD]10[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]20[/TD]
[TD]Feb[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]30[/TD]
[TD]Feb[/TD]
[/TR]
</tbody>[/TABLE]

The YTD total I'm getting for Feb is 160
The YTD total I want for Feb is 135 i.e. based on only those entities present in the month (C, D, E)

If for example March only had E=30 then I would want the YTD to show 90.

Please help. Thanks,
Gregg

 

[Ozeroth]

You just need to add VALUES( tablename[Entity]) (or whatever the column is called) as a second filter argument to CALCULATE, to filter on those values in the current filter context:

FallYTD :=CALCULATE (
    SUM ( [Falls] ),
    DATESYTD ( tablename[Date] ),
[B][COLOR=#ff0000]    VALUES ( tablename[Entity] )[/COLOR][/B]
)