Forum Discussion
nick1097
2 years agoFrequent Visitor
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...
- 2 years ago
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!
nick1097
2 years agoFrequent Visitor
The data model is really simple. All data for this described case is in the fact table (TableX). I am not using data from dimension tables.
Gabry
2 years agoSuper User
just try this then
Process Time B =
CALCULATE(
AVERAGE(
TableX[Process Time]
),
TableX[Product] = "B",
All(TableX)
)