Filter out id with missing values

[Hardik]

Hi,

I need help here to filter out fields with empty values in either of the task category ( i.e Development or Testing).

Please follow the link below: 

https://drive.google.com/drive/u/1/folders/1JA4gspp2Pjx3hy-PZo1QCh1h_KsfeMJP

Thanks,

Hardik

[v-shex-msft · Accepted solution]

HI @Hardik,

You can use below measure to instead task_id column to achieve filter effect.

Result = 
VAR _distinct =
    CALCULATE (
        DISTINCTCOUNT ( Tasks[Task_Category] ),
        FILTER (
            ALLSELECTED ( TaskAssignment ),
            [Emp_ID] IN VALUES ( Employee[Emp_ID] )
                && [Date] = MAX ( TaskAssignment[Date] )
        )
    )
VAR category_count =
    COUNTROWS ( DISTINCT ( ALLSELECTED ( Tasks[Task_Category] ) ) )
RETURN
    IF ( _distinct = category_count, COUNT ( TaskAssignment[Task_ID] ) )

Regards,

Xiaoxin Sheng