Tooltip to show totals for Stacked Bar chart by excluding the grouping used in legend

[Anonymous]

Hi,

I am trying to show tooltip for Stacked Bar chart, i.e I have Unit types  A,B,C,D,E,F,G,H,I,J,Others.

And have a another grouping(time period) which I am using in legend 0-30, 31-60, 61-90,....

I want to show in the tooltip the total each Unit Type, but in the tool tip it is showing the total for each Unit type and time period, please see the image below

In the above image, Current units is the units by Type and Time period, I have created a measure Test Totals to get the totals for each type by using all except.

But the problem now is if I filter the page with other filters, the measure test Total doesn’t give me the filtered values instead it still gives me the same total.

Could anybody please help me in this regard?

Thanks in Advance

[parry2k]

@Anonymous try this measure

Tooltip = 
VAR __t = MAX( 'Table'[Unit Types] ) 
RETURN 
    CALCULATE( 
        SUM( 'Table'[Amount] ),
        ALLSELECTED( 'Table'[Time Period] ), 
        'Table'[Unit Types] = __t
    )

[Anonymous]

Hi @parry2k ,

Thanks for your suggesstion,

But it returned the same value as my Current Units.

[parry2k]

@Anonymous can you share sample dataset and your data model. I expected it to work, may be I'm missing something.