How to have a Tooltip show a full list of values based on the Matrix column header hovered over?

[D_PBI]

Hi,
I have a Matrix visual that show Subjects on the rows and People on the columns. There is a Chiclet slicer visual that filters the Matrix. All is working as it should be at this point.
I would like to create Tooltip so when the user hovers over a cell value (regardless which row/column intersect cell) a Tooltip appears showing all Subjects (ignoring the Matrix's row context and the Chiclet slicer filtering) for the Person in which the column hovering is taking place.
For example, take a look at the below visual


If the user was to hover over any cell under the 'Super Ted' user column, a Tooltip (containing a Table visual) would appear listing all lowest level values (in the visual above the lowest level (level 4) of the hierarchy is expanded for 'Enterpreneurial experience'). So the Tooltip would show a long list of lowest hierarchy level values, however many values the person has a 1 for, which is not filtered by the Chiclet slicer or the Matrix's row context.

I've tried a few different DAX measures so far, none have worked. Below is my latest effort. The is a relationship (1 to * ) between the Checklist and the Mentor tables. The Chiclet slicer values are tied to the Checklist table's Level 2 hierarchy. In the Matrix itself is the Checklist table's Level 3 values, which in turn can be expanded to the Level 4 values.

Mentor Checklist =
CALCULATE (
    CONCATENATEX ( Checklist, VALUES ( Checklist[Level 4] ), " " ),
    ALLEXCEPT ( Mentor, Mentor[Mentor Name] )
)

Please can someone inform me if what I am trying to do can be done?
Then how to write the DAX Measure to achieve it?

Thanks.

[PtoLtoC]

Hi @D_PBI ,
Interesting workaround, do you have any idea on how to display all level 4 by row instead of a concatenate cell?
Best

[dax]

Hi @D_PBI , 

I am not clear about your requirement, could you please explain "If the user was to hover over any cell under the 'Super Ted' user column, a Tooltip (containing a Table visual) would appear listing all lowest level values (in the visual above the lowest level (level 4) of the hierarchy is expanded for 'Enterpreneurial experience'). " to me in details? 

If you don't want context or slicer to affect the tootips, you could try to disable "keep all filters" in Tooltip page, Then show value in details not summarize data in tooltip.

Best Regards,
Zoe Zhi

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

[D_PBI · Accepted solution]

@dax - Zoe, thanks for your response.
I've managed to solve this myself by creating the following measure, that is embedded into the Tooltip visual.

__Tooltip =

CALCULATE(

     CONCATENATEX(

                                 Checklist,

                                 Checklist[Level 4],

                                 " "

                                 ),

     ALL( Checklist )

)