Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Display rows with multiples criteria

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)
 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , 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])))