Forum Discussion

aflintdepm's avatar
aflintdepm
Helper III
2 years ago
Solved

Count Rows on another table based on attributes on main table

I have 2 tables, one is a list of employees with employment status and the other is a list of tasks assigned to those employees with the task status.  Everthing is linked by EE_ID, but I did have to ...
How-to
  • Samarth_18's avatar
    Samarth_18
    2 years ago

    Hi aflintdepm ,

     

    You could use below measure - 

     

    Measure =
COUNTROWS (
    FILTER (
        'Task table',
        'Task table'[EE_ID] = MAX ( EE_Status[EE_ID] )
            && 'Task table'[Task_Status] = "Incomplete"
            && MAX ( EE_Status[Status] ) = "Terminated"
    )
) + 0

     

    output -

     

     

Samarth_18's avatar
Samarth_18
Community Champion
2 years ago

Hi aflintdepm ,

 

You could use below measure - 

 

Measure =
COUNTROWS (
    FILTER (
        'Task table',
        'Task table'[EE_ID] = MAX ( EE_Status[EE_ID] )
            && 'Task table'[Task_Status] = "Incomplete"
            && MAX ( EE_Status[Status] ) = "Terminated"
    )
) + 0

 

output -

 

 

  • aflintdepm's avatar
    aflintdepm
    Helper III
    2 years ago

    Samarth_18 
    Thank you for the response.  Can you please clarify the function of the MAX in the measure?  Other than that, I believe I understand the syntax

    • Samarth_18's avatar
      Samarth_18
      Community Champion
      2 years ago

      aflintdepm , It's just to pick a value of EE_ID, Status from the current context.