Forum Discussion

Iceberg12's avatar
Iceberg12
Frequent Visitor
2 years ago
Solved

Need help to find missing Data

Hello everyone,  I am new to PowerBI and I need your help with the following: I have a table like this Component Missing A yes A yes B no C no C no D yes   ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Iceberg12 

 

 

step 1 : create a table visual

step 2 : drag and drop into the visual the column "  Component " 

 

step 3 : in the filter pane, drag to the section , filter on this visual , --> Missing 

 

step 4 : set your filter =  yes

 

this should work ..

 

 

 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠