ArcGIS Map, is there a way to limit how data is sliced based on status?

[suraetay]

Hello all,

I'm working on a Power BI mapping visual that shows our project locations across the country, with a slicer for their added date. I have a request to add in all our ordered, but not started, projects, and display them regardless of their start date. Right now the table I'm using has a column for project addresses and a second for the project status, with the ordered-but-not-started projects identified as "Open" and the rest marked as "Activated."

My guess is that I may need to add in the open projects as a custom base layer from ArcGIS, but we don't currently have an ArcGIS account. Is there another way I can get this to work?

TIA!

[suraetay · Accepted solution]

I was actually able to solve this myself after a lot of digging. Here's the query I used, I hope it's helpful for others. I then applied this measure to "Filters on this visual" and indicated to include those where the value is greater than 0. Attaching a screenshot of the visual result too.

include_open_projects = 
VAR mindt = MINX(ALLSELECTED('DATE'[Date]), 'DATE'[Date])
VAR maxdt = MAXX(ALLSELECTED('DATE'[Date]), 'DATE'[Date])

RETURN
CALCULATE(
    COUNTROWS(
        FILTER(address_table,
        (address_table[lead_project_added_dt] >= mindt && 
        address_table[lead_project_added_dt] <= maxdt)
        ||
        ISBLANK(address_table[lead_project_added_dt]))),
        REMOVEFILTERS('DATE'))