cumulative total tooltip

Question

Hi I trying to create a tooltip report page that I can use to show cumulative total.&nbsp;Problem is cumulative total is showing in data labels but when I use it in tooltip report page it is showing values of that month only but not the cumulative total.Original DAX which is showing right cumulative total in data labels -&nbsp;14.2 Cumulative Actual Cost CY running total in Month =VAR SelectedMaxDate = MAX('Dim_Calender'[Date]) &nbsp;-- from slicerVAR CurrentRowDate = MAX('Su_Calender Trend'[Date]) &nbsp;-- from visual context&nbsp;RETURNIF(&nbsp; &nbsp; CurrentRowDate &lt;= SelectedMaxDate,&nbsp; &nbsp; CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; [14.2 Cumulative Actual Cost CY],&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend'[Monthnum],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend'[Month],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend'[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED('Su_Calender Trend')&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ISONORAFTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend'[Monthnum], MAX('Su_Calender Trend'[Monthnum]), DESC,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Su_Calender Trend'[Month], MAX('Su_Calender Trend'[Month]), DESC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ),&nbsp; &nbsp; BLANK())

pragati11 · Accepted Answer

HI&nbsp;Anonymous&nbsp;
If I understand correctly, your custom tooltip needs to show cumulative total without getting filtered for that month.
In that case it will always show a single value right?
Can you add little bit more details here please?
&nbsp;
Also the DAX that you have shared above has got an ALLSELECTED which is basically filtering the totals for the month when shown on a custom tootltip.
If you modify it to ALL, then it should always show your one cumulative total irrespective of what month you hover it on.&nbsp;
Basically the updated dax will be:
14.2 Cumulative Actual Cost CY running total in Month =
VAR SelectedMaxDate =
    MAX ( 'Dim_Calender'[Date] ) -- from slicer
VAR CurrentRowDate =
    MAX ( 'Su_Calender Trend'[Date] ) -- from visual context
RETURN
    IF (
        CurrentRowDate &lt;= SelectedMaxDate,
        CALCULATE (
            [14.2 Cumulative Actual Cost CY],
            FILTER (
                CALCULATETABLE (
                    SUMMARIZE (
                        'Su_Calender Trend',
                        'Su_Calender Trend'[Monthnum],
                        'Su_Calender Trend'[Month],
                        'Su_Calender Trend'[Date]
                    ),
                    ALL ( 'Su_Calender Trend' )
                ),
                ISONORAFTER (
                    'Su_Calender Trend'[Monthnum], MAX ( 'Su_Calender Trend'[Monthnum] ), DESC,
                    'Su_Calender Trend'[Month], MAX ( 'Su_Calender Trend'[Month] ), DESC
                )
            )
        ),
        BLANK ()
    )

Let me know if this helps.
&nbsp;

Forum Discussion

cumulative total tooltip

1 Reply

Related content

Cumulative Total

Cumulative Total

SumX? - cumulative running total

Cumulative Total

Cumulative total tooltip