Running Total not working correctly on Custom Tooltip
Hi All, I have a Running Total measure _ActualCost Test RT that works correctly on a Column chart and a table visual, but when placed onto a custom tooltip to show the data for the column chart visual it seems to only provide the month value. So for the month of September FY 2023 the _ActualCost Test RT should be displaying $7,837,046 but the tooltop is showing $2,291,617. Note: The reason I need a custom tooltip is because I need to use a clustered column chart. _ActualCost = CALCULATE( SUM(ZISU_RPT_DCSTRV[AMOUNT]), FILTER('GL ACCOUNT HIERARCHY', 'GL ACCOUNT HIERARCHY'[Revenue]=BLANK() && LEFT('GL ACCOUNT HIERARCHY'[G/L Account Name],3) <> "ASS" && 'GL ACCOUNT HIERARCHY'[G/L Account Grouping] <> "Settlements")) _ActualCost Test RT = CALCULATE( [_ActualCost], FILTER( CALCULATETABLE( SUMMARIZE('DimDate', 'DimDate'[Fiscal Year], 'DimDate'[FY Fiscal Year], 'DimDate'[Fiscal Period], 'DimDate'[MonthNameLong]), ALLSELECTED('DimDate') ), ISONORAFTER( 'DimDate'[Fiscal Year], MAX('DimDate'[Fiscal Year]), DESC, 'DimDate'[FY Fiscal Year], MAX('DimDate'[FY Fiscal Year]), DESC, 'DimDate'[Fiscal Period], MAX('DimDate'[Fiscal Period]), DESC, 'DimDate'[MonthNameLong], MAX('DimDate'[MonthNameLong]), DESC ) ) )
