Forum Discussion

Låret's avatar
Låret
Frequent Visitor
4 years ago
Solved

Filter from customer ruins time intelligence

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!

 

 

  • 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. 

3 Replies

  • Låret's avatar
    Låret
    Frequent Visitor

    Without the filter from customer it looks like this :

     

  • Låret's avatar
    Låret
    Frequent Visitor

    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.