Forum Discussion
CALCULATE function result changes by using slicer
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!
Again, this leads to no filtering at all.
Process Time B =
CALCULATE(
AVERAGE(
TableX[Process Time]
),
Filter(All(TableX[Product]),
TableX[Product] = "B",)
)
if not paste the pbix
That works!Is there any possibility to do that without a FILTER-function to save performance? That was also my initial objective.
Already tried this?
Process Time B =
CALCULATE(
AVERAGE(
TableX[Process Time]
),All(TableX[Product]),
TableX[Product] = "B")
Do you really have performance issue using filter or it's just speculation?As i know every filter put in the calculate functions it gets converted behind the scenes in a filter so
First of all, thank you for your time and help!
I tried this already. With that it shows the same values like the original code:
Process Time B = CALCULATE( AVERAGE( TableX[Process Time] ), TableX[Product] = "B" )
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!