Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cross referencing with in the same table

Hello,   I have a data set that references the employees in two columns. But I need to compare them. When I conduct a count formula, to distinguish the number of cases assigned by an employee and t...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    You can try to use the following measure formula to calculate the field aggregated based on current employee group:

    #Assigned by =
CALCULATE (
    COUNT ( 'Interpreter usage report'[Assigned by.1] ),
    ALLSELECTED ( 'Interpreter usage report' ),
    VALUES ( 'Interpreter usage report'[Employee] )
)

#Scheduledby =
CALCULATE (
    COUNT ( 'Interpreter usage report'[Scheduled by.1] ),
    ALLSELECTED ( 'Interpreter usage report' ),
    VALUES ( 'Interpreter usage report'[Employee] )
)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI Anonymous,

You can try to use the following measure formula to calculate the field aggregated based on current employee group:

#Assigned by =
CALCULATE (
    COUNT ( 'Interpreter usage report'[Assigned by.1] ),
    ALLSELECTED ( 'Interpreter usage report' ),
    VALUES ( 'Interpreter usage report'[Employee] )
)

#Scheduledby =
CALCULATE (
    COUNT ( 'Interpreter usage report'[Scheduled by.1] ),
    ALLSELECTED ( 'Interpreter usage report' ),
    VALUES ( 'Interpreter usage report'[Employee] )
)

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Sorry for the delay, but that did not resolve my issue. The numbers are inaccurate.