0 votes

Can someone explain the difference in the results of the CALCULATE function when using it with and without FILTER function?

Given-below the scenario:

```Measure21 = CALCULATE([A], 'FactTable'[Color]="Blue")

Measure12 = CALCULATE([A], FILTER('FactTable', 'FactTable'[Color]="Blue")``` Sep 24, 2020 in Power BI 404 views

## 1 answer to this question.

0 votes

You could make [Measure12] return the same results as this:

`CALCULATE([X], FILTER(ALL('FactTable'[Color]), 'FactTable'[Color]="Blue")`

Using FILTER has a significant performance impact, which can be clearly seen looking at query plans and utilization of Storage Engine vs Formula Engine.

FILTER retains and iteracts with initial filter context, while filter expression used directly in CALCULATE ignores it. answered Sep 24, 2020 by
• 65,870 points

0 votes
1 answer

## Calculate and filter function - DAX

Hi Praneeth, Calculate () by default perform calculations ...READ MORE

0 votes
1 answer

## Hi, I am learning Power BI and trying to understand how calculate works without filter? = calculate(sum(sales.total_amout)). why cant we give sum(sales.total_amount)?

Hello @Amitha, The CALCULATE function is useful because ...READ MORE

0 votes
1 answer

## How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

0 votes
1 answer

## calculation with condition and filter

Hi Preethi, Follow the below steps: 1. Create a ...READ MORE

0 votes
1 answer

## Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

0 votes
1 answer

## DAX Userelationship function

You need a way for the measure ...READ MORE

0 votes
1 answer

## Using RELATED function in DAX with USERELATIONSHIP

Here's an example using the AdventureWorksDW data ...READ MORE

0 votes
1 answer

## How to restart running total column with Power BI Desktop DAX?

This is not only a running total ...READ MORE

0 votes
1 answer

## Understanding the DAX CALCULATE function

Using the CALCULATE function makes the DAX perform a context ...READ MORE

0 votes
1 answer

## DAX function to create LY Measure without date dimension

It should be fairly simple (sumx of ...READ MORE