Power BI DAX measure : Select lines with condition

[PBIBeginner2022]

Hello everyone,

I have a table with lots of column and I want create a DAX measure between three columns of this table (OrderNumber, ExtractionDate and EstimateDeliveryDate). I want a measure which display all my OrderNumber which have an EstimateDeliveryDate inferior to ExtractDate.

Could you help me please ?

[johnt75]

You could create a measure to use as a visual filter on a table or matrix, like

Delivery Date Before Extract Date = IF ( SELECTEDVALUE( 'Table'[Delivery Date]) < SELECTEDVALUE('Table'[Extract Date]), 1)

Put your order number in a table visual and then add this measure as a filter to only show when the value is 1