I want the grand total to repeat across all categories once I select the Disconnected date filter

[Ajibao03]

@v-denglli-msft 

I need to create a measure that would repeat the grand total of the Total YTD column as the Total Amount. Currently the measure I created is throwing up the ITM grand total as the Total Amount which is not meeting up to the requirement.

For clarity, what I need is that once I select the Disconnected date filter, the corresponding Grand Total for "TotalYTD" should appear across the "TotalAmount" Column. e.g 

Based on the current selection, the value that is expected to appear across the second column is 1400 which is the grand total of "TotalYTD".

I have attached the link to the pbix file as well as a screenshot for your reference.

Any help is appreciated,

Link to file 

[mark_endicott · Accepted solution]

@Ajibao03 - DAX is below file is attached.

IF( ISFILTERED( 'Disconnected Table' ), CALCULATE( [TotalYTD], ALL( SalesTab[Category] )))

If this works for you please accept as the solution, it helps others with the same challenge. 

[Ajibao03]

Thanks . It worked