Forum Discussion

kongyuancn's avatar
kongyuancn
Helper II
3 years ago
Solved

context in Tooltip page

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("i45WcjRU0lFyAhHOhkqxOkABI7iAEUTAGF0FWIsRkg...
  • Greg_Deckler's avatar
    3 years ago

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