Straight Table Calculation Condition

[Ja4]

In a straight  table I need to filter where the duration is greater than  or equal to 2 days.

Source data is a VizLib writeback table.

I've tried a calculated dimension :  =Aggr(([End Date]-[Start Date]),tracker_id)

I've tried a measure too: Date#([End Date]-[Start Date])

Other columns:  Location / Status / Reason

[rubenmarin · Accepted solution]

Hi, if it's for a dimenions maybe: 

=Aggr(If([End Date]-[Start Date]>=2,tracker_id),tracker_id)

Or with a expression using a set analysis like:

{<tracker_id={"=[End Date]-[Start Date]>=2"}>}

[Ja4 · Accepted solution]

Thank you that put me in the right direction, I amended slightly:  =Aggr(If([End Date]-[Start Date]>=2,Reason),tracker_id), and then used with a measure to get the results I needed.