context in Tooltip page

[kongyuancn]

Hello all,

I met a context issue in Tooltip page.

Here is my data table

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcjRU0lFyAhHOhkqxOkABI7iAEUTAGF0FWIsRkgojuIAhkhaYilgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", type text}})
in
    #"Changed Type"

Which looks like:

And I create a slicer:

A also created a measure:

selected_A = CALCULATE(CONCATENATEX('Table', [A], ","), ALLSELECTED())

which shows all selected in slicer.

Which shows perfect:

Then I created a matrix:

and it looks like:

seems good.

Now I created a tooltip page which include this measure:

let matrix use this tooltip page. 

Now in tooltip it only shows "A2 A2", not "A1,A1,A2,A2". Can any one help to let it show "A1,A1,A2,A2"?

Thanks in advance.

[Greg_Deckler · Accepted solution]

@kongyuancn Agree with @Arkan_Hazm_ but, it can be done by adding a slicer table and this measure. PBIX is attached below signature.

selected_A1 = 
    VAR __Category = MAX('Table'[A])
    VAR __Values = DISTINCT('Slicer'[A])
RETURN
    IF(__Category IN __Values,
        CONCATENATEX(FILTER(ALL('Table'), [A] IN DISTINCT(Slicer[A])),[A], ","),
        BLANK()
    )

[Arkan_Hazm_]

I think you only see "A2 A2" because u hovering A2 column

Better to explain what you use this for?

Is this only for zooming the value ?

[kongyuancn]

Hi @Arkan_Hazm_ I just want to show the results are different for measure in matrix and in tooltip