Filter on date table won't show rows where date is blank
I wish to filter data on date, to show data within a date range (which currently works) OR with no date (ISBLANK() returns True). As I'm using multiple data sources, I created a 'Dates' table as follows :
As excepted, the Dates[Date comptable] column contains one blank row, and all the dates from the dataset.
I'm using the following filter on the report :
And it shows no data /
However, when I use another table, for example 'Table 1', PBI sucessfuly filters the empty dates and counts the elements :
I tried to modify the relations from -> to <->, and it doesn't work. I also wanted to create one-to-many relations, as I use 'Distinct' on my Dates table, but the editor won't let me chose this option (it says the cardinality isn't valid for this relation).