Forum Discussion

user-2024's avatar
user-2024
Frequent Visitor
1 year ago

Unselected value

Hi all, I'm trying to create comparison between data. In particular, I want to compare data of the selected Employee against the data of all the unselected employees. I have a filter on the page to...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

Hello user-2024,

 

Can you please tyr this approach:

Employee Category = 
VAR SelectedEmployee = SELECTEDVALUE(EmployeeTable[EmployeeName])
RETURN 
    IF(
        ISBLANK(SelectedEmployee),
        "All Employees",
        IF(
            EmployeeTable[EmployeeName] = SelectedEmployee,
            "Selected Employee",
            "Other Employees"
        )
    )
  • user-2024's avatar
    user-2024
    Frequent Visitor
    1 year ago

    Thanks for the reply.
    The scatter chart does not allow me to put a measure as a legend