DAX measure for report tooltip

[Simo2024]

Hi,
I am new to power BI and facing issues with a conditional tooltip.
I have a combined table with all the data I need. (see sample data bellow).

And I created a report gruoping the products by code and displaying the min, max and average unit price 

I want to be able to see the technical specification (could be one value or many) when I hover over the min or max values.
I have been testing few dax code to create a measure and use in the tooltip, but I couldn't get it to work.
Note that one code can have multiple technical specifications and unit costs, the logic I am using is e a condition combining  the code and unit price to display the coresponding technical specifications.

bellow is my latest attempt, that generates an error code (MdxScript(Model) (4, 1)

Tooltip =

VAR SelectedID = SELECTEDVALUE('Combined table'[code])

VAR SelectedValue = SELECTEDVALUE('Combined table'[Eur/Unit])

VAR Resulttable=

   CALCULATETABLE(

        'Combined table',

        'Combined table'[code] = SelectedID && 'Combined table'[Eur/Unit] = SelectedValue

    )

    RETURN

   VALUES('Combined table'[Technical specification])

Thank you in advance
Simo

[Jihwan_Kim]

Hi, I am not sure if I understood your question correctly, but please try to use the below DAX function.

CONCATENATEX function (DAX) - DAX | Microsoft Learn

Tooltip measure: =
CONCATENATEX (
    'Combined table',
    'Combined table'[Technical specification] & " " & 'Combined table'[Eur/Unit],
    " | "
)

[Simo2024]

Hi,
Thank you for your reply and applogies if my question wasn't clear.
I 'll try to explain it a bit further.
The end result would be that if I hover over the min or max unit price in the report the tooltip would display all the technical specifications coresponding to the selected unit price and its code.

Eg: if I hover over the unit price highlighted in red it should check the code highlighted in blue and unit price in the source table and display the technical specifications highlighted in green that match them.

Thank you again