Replace Datetime with BLANK, when another value is notblank

[JamesK5613]

Hi All, 

I'm having trouble figuring out how get a value to show in a visual as needed. Example datatable is this 

ID	DateTime	Delay/Cancellation	Reason
1	23/06/2023 10:00	Delay	Transport
2	24/06/2023 10:00	Blank	Blank

I need the visual table to show only the 24/06/2023 date, but still have the other ID in so  

ID	DateTime	Delay/Cancellation	Reason
1
2	24/06/2023 10:00	Blank	Blank

So if an ID has a DateTime with Blank, Blank, it is displayed in the visual, If however the Delay/Cancellation has either Delay or Cancellation as a value, then the datetime, delay/cancellation and reason would show as blank. 

This datatable is refreshed frequently with more rows daily. 

Thank you in advance!

[Sahir_Maharaj]

Hello @JamesK5613,

Can you please try creating a new measure:

FilteredTable =
VAR SelectedDate = DATE(2023, 6, 24)  // Change the date as needed
RETURN
    IF(
        ISBLANK(MAX('Table'[Delay/Cancellation])) ||
        MAX('Table'[Delay/Cancellation]) = "Blank" &&
        MAX('Table'[DateTime]) = SelectedDate,
        MAX('Table'[ID]),
        BLANK()
    )

By adding the "FilteredTable" measure to your visual table, it should only show the rows where the date is equal to the selected date and the 'Delay/Cancellation' column has a value of "Blank" or is blank.

Do not hesitate to let me know if you might need further assistance.