Running Total not working correctly on Custom Tooltip

[Anonymous]

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
        )
    )
)

[Anonymous]

Hi @Anonymous ,

Please try:

1. Close keep all filters on the tooltip page.
2. Modify the measure.

_ActualCost Test RT = SUMX(VALUES(Table[MonthNameLong), [_ActualCost])

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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