CALCULATE With FILTER or Without Which is BETTER ?

Question

These two formulas lead to the same resultsWhich one is better to use ?-----------------------------------Formula 1:Sales in europe = CALCULATE(SUM(Sales[Cost]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Region'[Group]="europe",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Region'[SalesTerritoryKey]=10)-----------------------------------Formula 2:Sales in europe2 = CALCULATE(SUM(Sales[Cost]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(Region,'Region'[Group]="europe"),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER('Region','Region'[SalesTerritoryKey]=10)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;

antrikshsharma · Accepted Answer

mrsja2024&nbsp;Formula 1 is better approach but if the result should be same as Formula 2 in EVERY situation then you need to include KEEPFILTERS as well, right now it is working because you're not using Group &amp; SalesTerritoryKey columns in the report.Sales in europe =
CALCULATE (
    SUM ( Sales[Cost] ),
    KEEPFILTERS ( 'Region'[Group] = "europe" ),
    KEEPFILTERS ( 'Region'[SalesTerritoryKey] = 10 )
)It is a best practice to filter only columns and not the whole table.&nbsp;Use FILTER when you bring columns from different tables and have to filter out some combinations.&nbsp;

Forum Discussion

CALCULATE With FILTER or Without Which is BETTER ?

2 Replies

Related content

Calculating with Filters

Calculate Filters

How to search specific word in table filter Calculations

Calculation Group Filters

How to use FILTER() inside CALCULATE()