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 select a single employee, trying to use the selected/unselected as legend of a scatter chart. Is it possible?
Example:
Employee A, employee B, employee C. If the user select in the filter employee A, the scatter chart will show the points of employee A and then employee B + employee C as "Other employees".
Thanks

Need Help

5 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from Sahir_Maharaj.

     

    Hi user-2024,

     

    Based on your description I created simple data:

     

    Create two new tables on top of this, one for the legend of the scatter chart and one for the slicer.

     

    Then create a measure:

    Measure = 
VAR _selected=SELECTCOLUMNS('EmployeeSlicer','EmployeeSlicer'[Employeename])
VAR _unselected=EXCEPT(ALL('EmployeeTable'[Employeename]),_selected)
VAR _unselectedtotal=SUMX(FILTER(ALL('EmployeeTable'),'EmployeeTable'[Employeename] IN _unselected),'EmployeeTable'[Value])
RETURN 
SWITCH(MAX('NewEmployee'[Employeename]),"other employees",_unselectedtotal,SELECTEDVALUE('EmployeeSlicer'[Employeename]),SUM('EmployeeTable'[Value]))

     

    Results:

     

    Best Regards,
    Zhu

     

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

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

      Thanks for the reply. The output is near to what I wanted, but there's still somethinf to fix. I exaplin better the expected result.
      As you see in the image, for the active employee (light blue) the dots are okay. While for the Others, the value is constant to the average of all of them, regardless of the x-axis. Is it possible to have also for the Others employee, not an aggregation, but all the points with their single value?
      Expected outcome:

       

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

      Also in your sample data, the others employee total doesn't reflect the year, but it's constant considering both 2023 and 2024.