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
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.