dynamic tooltips with parameter

Hi newlearn123 ,
Thank you tamerj1   very much for the solution, and I've tried other ways to help you understand the problem:

Based on your error message, it appears that the table is using composite keys.

When I used your code, I made sure that there were only Parameters in the 'ParameterSlicer' column and that my ParameterSlicer table had no complex relationship with the Employee table, and your code is working perfectly.

Selected_Number = Var CurrentSlicerValue = selectedvalue('ParameterSlicer'[Parameter])

Return

SWITCH(

  True(),

CurrentSlicerValue = "A", "A Number: " & MAX('EmployeeData'[A_Number]),
   CurrentSlicerValue = "B", "B Number: " & MAX('EmployeeData'[B_Number]),
   CurrentSlicerValue = "C", "C Number: " & MAX('EmployeeData'[C_Number]),
   BLANK()
)

If after trying the above you still don't solve the problem, you can also use the Allexcept function to filter out the other columns, here is the documentation on Allexcept.it would be helpful if you could provide me with your data to find a solution. Thanks.

ALLEXCEPT function (DAX) - DAX | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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