Filter from customer ruins time intelligence

[Låret]

Hello for some reason, when a filter is coming from the customer table, the PY calculation breaksdown.

Sales gives the correct value for each customer group and year for the current year but py year returns blank. 

Here is the model: 

 

Thanks for any ideas!

[Låret · Accepted solution]

Sorry for not answering. The problem was that i accidentally had made a relationship between the date table and another fact table bidirectional. Changing it solved the problem. 

[Låret]

Without the filter from customer it looks like this :

[Anonymous]

HI @Låret,

Can you please share some dummy data with raw table structures and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng