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!
Process Time B =
CALCULATE(
AVERAGE(
TableX[Process Time]
),
Filter(All(TableX[Product]),
TableX[Product] = "B",)
)
if not paste the pbix
I oversaw something. It doesn´t work after all.
Sounds really strange to me. Maybe paste the pbix I don't know
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!