Forum Discussion

MURTAZA's avatar
MURTAZA
Resolver I
5 years ago
Solved

CONCATENATE DISTINCT VALUES in Tooltip

Hi All, I am trying to create a custom tooltip for a table and matrix visual. My table is like this.  Department Employee Percentage Dept-A Emp-1 50% Dept-A Emp-2 100% Dept-A ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    MURTAZA , both values are .5 

     

    You can try like 

    Tooltip = 
CALCULATE(
CONCATENATEX(
        SUMMARIZE(Sheet1,Sheet1[Employee],
        Sheet1[Percentage]),[Percentage]
        ),
        ALLEXCEPT(Sheet1,Sheet1[Employee])
        )

     

amitchandak's avatar
amitchandak
Super User
5 years ago

MURTAZA , both values are .5 

 

You can try like 

Tooltip = 
CALCULATE(
CONCATENATEX(
        SUMMARIZE(Sheet1,Sheet1[Employee],
        Sheet1[Percentage]),[Percentage]
        ),
        ALLEXCEPT(Sheet1,Sheet1[Employee])
        )

 

MURTAZA's avatar
MURTAZA
Resolver I
5 years ago

amitchandak 

My apologies that I forgot to mention 1 important aspect of my data is that I have created a unique ID column that I am using, instead of the employee ID (this is because of the limitation Matrix visual has of aggregating data. The duplicated employee IDs, within a department, were aggregated to show as 1, so I had to create a unique ID. This formula is not working in this scenario now, which is understandable, as it is unable to find distinct values. Can you help and advise on this please?

 

 

 

Tooltip =

CALCULATE(

CONCATENATEX(

 SUMMARIZE(

 Sheet1,

 Sheet1[Unique ID],

 Sheet1[Percentage]

 ),

 [Percentage]

 ,", "),

 ALLEXCEPT(Sheet1,Sheet1[Unique ID]

 ) )