ALLSELECTED: Selecting the *wrong* column filter gives the *correct* result? (in CALCULATE function)

[wad11656]

This formula gives the following result:

Furniture Total = CALCULATE([OPC Total], ALLSELECTED('MyTable'[OPC]))

Furniture Total = Add line items with matching Company names:

Company1: $32,494,925.41 + $44,115,186.84 = $76,610,112.25

Company2: $2,907,016.22 + $4,261,988.05 = $7,169,004.27

Company3: $14,796,661.94 + $16,265,809.15 = $31,062,471.09

However, isn't this formula wrong?

Why is it adding line items with matching Company names? I ALLSELECTED the OPC column in my filter, so shouldn't it be adding line items with maching OPC names?

Oddly (to me), when I ALLSELECTED the *Company* column in my filter, it adds values with matching OPC names!:

Furniture Total = CALCULATE([OPC Total], ALLSELECTED('MyTable'[Company]))

Furniture Total = Add line items with matching OPC names:

ANCILLARY PRODUCT: $32,494,925.41 + $2,907,016.22 + $14,796,661.94 = $50,198,603.57

Primary Product: $44,115,186.84 + $4,261,988.05 + $16,265,809.15 = $64,642,984.04

These 2 formulas seem to do the opposite of what I'm specifying. Can anyone help me understand why?

Perhaps this misunderstanding is due to me not understanding the functionality of <filter> in CALCULATE(<expression>, <filter>). Can someone help me understand?

Thank you

[Anonymous · Accepted solution]

Hi @wad11656 ,

ALLSELECTED removes filter from the selected column of a table.

In your 1st example you removed filter of the [OPC] column, hence only the company filter was active.

In your 2nd example you removed filter of the [Company] column, hence only the OPC filter was active

Hope that helps

BR

[wad11656]

So the word "filter" really means "filter OUT". Got it. Thanks!