Need help to find missing Data

Hi Iceberg12 ,

Please try below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Count Of Missing =
VAR cur_component =
    SELECTEDVALUE ( 'Table'[Component] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), [Component] = cur_component && [Missing] = "yes" )
RETURN
    COUNTROWS ( tmp )

3. add a table visual with field and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.