Date Filter on Two Different Date Columns

Power BI Data Model
5

my solution with similar issues has been to create a measure to use as filter - this does NOT have to be visible in the final output.

Create measure:

Using Opened Date = 
CALCULATE(
    COUNTROWS( Test ),
    USERELATIONSHIP( Test[Opened Date],'Date Table'[Date] ))

and add that to the table filters in the filter pane:
image

but do not add it to the values of the table visual:
image

updated example attached
eDNA solution - Filtering table with invisible Measure.pbix (116.9 KB)

4 Likes