Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count with dynamic filter

Hello,   I need some help on a formula dax.   I have an Employee table with an ID I have a Training table with the year of training and the employee ID   I would like to have the number of emp...
  • johnt75's avatar
    johnt75
    4 years ago

    Presuming that the slicer will filter the Training table, you could use

    Not done training =
VAR allEmployees =
    ALL ( 'Employees'[ID] )
VAR doneTraining =
    VALUES ( 'Training'[Employee ID] )
RETURN
    COUNTROWS ( EXCEPT ( allEmployees, doneTraining ) )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Presuming that the slicer will filter the Training table, you could use

Not done training =
VAR allEmployees =
    ALL ( 'Employees'[ID] )
VAR doneTraining =
    VALUES ( 'Training'[Employee ID] )
RETURN
    COUNTROWS ( EXCEPT ( allEmployees, doneTraining ) )