Contiguous Selection - Date Column Comes from a Table on the 1-side of a Bi-directional Relationship

[SHS]

Hello, 

After searching and reading multiple articles regarding this, and yet to find a solution, I hope that some can come to my rescue.

Before start explaning, let me just note, that this approach has worked perfectly when developing my report all day - only in the last 1 hour it seems to have messed it all up!

I have created a DateTable ranging from 01.01.2015-31.12.2050, set it as my primary date table and created a one-to-many relationship with my SalesTable.

For Sales YTD = TOTALYTD(SalesTable[NSV_B],DateTable[Date])

For Sales LYTD = CALCULATE([Sales YTD],SAMEPERIODLASTYEAR(DateTable[Date])

Additionally, as I have some orders in my SalesTable with a posting date at the end of May (Settlements) I have created a page-level filter stating that all Sales Orders with Posting Date after today should be excluded.

At last, I have created a page-level filter excluding all sales before 2017 as I only want to look at 2018-YTD.

As said in the beginning, there has been no issues with this approach. Everything has worked fine, until I opened the file again a couple of hours later, with the Contiguous Selection Error popping up. 

I have tried checking if I missed some dates in my DateTable but based on a simple Day Count in Excel I can see that this is not the case.

Please help! 😞 

[HashamNiaz]

Hi @SHS !

Please elaborate why you are using bidirectional filter for this relationship. Once you changed the filter to single. It will resolve the issue. 

It seems the Sales table is trying to filter out Date dimension table and Page level filter not able to find specific rows used in filter expression.

Regards,

Hasham

[SHS · Accepted solution]

HI @HashamNiaz ,

The filter is only 1-way (DateTable --> SalesTable) - Sorry if misexplained. But it didn't solve. 

What I meant in relation to the page-level filter is that from the DateTable I made a statement saying that if the Date in DateTable was before the first date or after the last date in my SalesTable it should be excluded from the overview, due to using the DateTable Dimensions as Axes in my visuals on the page. 

I have not been able to create a calendar only from the SalesTable as I have other Fact Tables related to other Sales Figures (Order Intake, Backlog, Pipeline etc.).

However, I solved the issue by changing my Exclusion Statement from FIRSTDATE/LASTDATE to MIN/MAX - Though this does not sound logical to me, as the first worked fine before, it seemed to fixe the issue