Forum Discussion
Solved
CALCULATE function result changes by using slicer
Hello all, I hope you can help, I think it is just a matter of understanding the filter in CALCULATE. I am currently using a calculate function and I can´t explain the result myself. For example...
I found the problem. The value was influenced by the date-slicer, that was referencing the date column of the fact table. Since I created a date dimension table and changed the reference of the slicer, it works with only a CALCULATE function!
Do you have a DIM tabel or you are just filtering from the fact column table?
Tablex is the fact or the dim?
Paste the screen of the model.
Anyway you probably need to put an all somewhere, maybe on the dim table