Forum Discussion
Solved
Difference between using filter and not using in calculate
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!
hama21 , This blog explains what you are looking for
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
2 Replies
hama21 , This blog explains what you are looking for
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
Hi,
I think the below blog will be useful :
https://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
