Show Column If Open

[ColtE8]

Hello,

I am creating a table and only want data to show up if the status of a column is open. I thought it should be simple but it's telling me error.

={$<Status={'Open'}>}

Why isn't this working?

I also would like to have them filter to show anything due in the next 30 days. I have a filter already for "Days until Due". I would love to include all of them together if possible so something like if the status is open and days until due < 30 then it shows up in the table. Hope that makes sense.

[Or]

That will work if it is included in an aggregation, but it can't just be placed in a measure by itself  - the set reduces the population, but you haven't specified what to return.

Only({$<Status={'Open'}>} Status) would work, for example (assuming this is a measure, in a dimension you may need to aggr() ).

[ColtE8 · Accepted solution]

Ya it's hard for me to ask questions here because of sensative data. I actually got it working though! I used:

=if(Status = 'Open' and [Days Until Due] < '30',[Unique Identifier])