topic Filter from customer ruins time intelligence in DAX Commands and Tips

Filter from customer ruins time intelligence

Låret — Fri, 11 Mar 2022 11:09:59 GMT

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!

Re: Filter from customer ruins time intelligence

Låret — Fri, 11 Mar 2022 11:14:37 GMT

Without the filter from customer it looks like this :

Re: Filter from customer ruins time intelligence

Anonymous — Mon, 14 Mar 2022 02:48:51 GMT

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

Re: Filter from customer ruins time intelligence

Låret — Wed, 20 Apr 2022 08:56:46 GMT

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.