Calculate the Total YTD of a subset of rows in a table

[webportal]

This is Table A and Table B:

How to calculate the TOTAL YTD of "Value" of Table B of only the ID's in Table A?

[MFelix · Accepted solution]

Hi @webportal ,

You need to create a measure similar to this one:

Total YTD =
CALCULATE (
    TOTALYTD ( SUM ( TableB[Value] ), TableB[Date] ),
    FILTER ( ALL ( TableB ), TableB[ID] IN VALUES ( TableA[ID] ) )
)