Forum Discussion
wad11656
Advocate I
Advocate IALLSELECTED: Selecting the *wrong* column filter gives the *correct* result? (in CALCULATE function)
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...
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
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
wad11656Advocate I
Advocate ISo the word "filter" really means "filter OUT". Got it. Thanks!