Difference between using filter and not using in calculate

[hama21]

Hi everyone,

My question I think is pretty simple. What the difference between these measures?

Measure A = CALCULATE(SUM('TABLE A'[COLUMN A]), FILTER('TABLE A', 'TABLE A'[COLUMN B] = 1))

Measure B = CALCULATE(SUM('TABLE A'[COLUMN A]), 'TABLE A'[COLUMN B] = 1)

Thank you!

[MahyarTF]

Hi,

I think the below blog will be useful :

https://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

[amitchandak · Accepted solution]

@hama21 , This blog explains what you are looking for

http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/