How do I calculate a Total YTD Sales revenue with disconnected table in Power Bi

[Ajibao03]

@Greg_Deckler 

This formular below keeps returning the in the month sales revenue based on the disconnected table filter  instead of YTD sales revenue

YTDSelectedSalesRev = VAR SYTDx = TOTALYTD([Sales YTD],'SalesTable'[Date])

Return

CALCULATE((SYTDx),

FILTER(

    'SalesTable','SalesTable'[Date]="Disconnected Table Date")

    )

    )

[v-denglli-msft · Accepted solution]

Thanks for the reply from AllisonKennedy, please allow me to provide another insight.
Hi @Ajibao03 ,

I am not sure how your semantic model is designed, here is my sample.
The SalesTable and the DisconnectedTable are as follows.

Then use the following measure to calculate Total YTD Sales revenue.

TotalYTD =
VAR _tb =
    DATESBETWEEN (
        'SalesTable'[Date],
        MINX ( ALL ( 'Disconnected Table' ), 'Disconnected Table'[Date] ),
        MAX ( 'Disconnected Table'[Date] )
    )
RETURN
    TOTALYTD ( SUM ( SalesTable[Amount] ), _tb )

The final result is as follows.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ajibao03]

Thanks. This works so well. @v-denglli-msft 

[AllisonKennedy]

@Ajibao03 

Variables are calculated where they are DEFINED. They are NOT calculated where they are called / used. So in your formula, the SYTDx is calculated in the default evaulation context of your visual you're using this measure in. The CALCULATE statement you're using isn't doing anything therefore.