Forum Discussion

nick1097's avatar
nick1097
Frequent Visitor
2 years ago
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...
Need Help
  • nick1097's avatar
    nick1097
    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's avatar
nick1097
Frequent Visitor
2 years ago

That works!

 

Is there any possibility to do that without a FILTER-function to save performance? That was also my initial objective.

Gabry's avatar
Gabry
Super User
2 years ago

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

  • nick1097's avatar
    nick1097
    Frequent Visitor
    2 years ago

    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"
)