Display rows with multiples criteria

[PBI_newuser]

Hi, I want to have a field if "Missing Invoice Date" is selected, only show rows that have "Missing Invoice Date"  =1 ,

I have created Column for the 3 missing dates but I am not sure how to create the measures by using the Column.  Here is the sample file.

Below are the criteria:

• Missing Invoice Date = PO Date entered but no Invoice Date
• Missing PO Date = Invoice Date entered but no PO Date
• Missing Shipping Date = Received Date entered but no Shipped Date

Missing Invoice Date = IF('Table'[PO Date]<>BLANK() && 'Table'[Invoice Date]=BLANK(),1,0)

Missing PO Date = IF('Table'[Invoice Date]<>BLANK() && 'Table'[PO Date]=BLANK(),1,0)

Missing Shipped Date = IF('Table'[Received Date]<>BLANK() && 'Table'[Shipped Date]=BLANK(),1,0)

[amitchandak]

@PBI_newuser , In case you need measure to count

Missing Invoice Date = Countrows(Filter('Table,'not(Isblank('Table'[PO Date])) && isblank('Table'[Invoice Date])))

Missing PO Date = Countrows(Filter('Table,'not(Isblank('Table'[Invoice Date])) && isblank('Table'[PO Date])))

Missing Shipped Date = Countrows(Filter('Table,'not(Isblank('Table'[Received Date])) && isblank('Table'[Shipped Date])))