Include values that got filtered out

[rcss]

Hi,

I have a working measure but it is filtering out some values that I want to be included in the calculation.

GADeviceBaseCommssions = 
CALCULATE(SUMX(CCRS, CCRS[Commission] + CCRS[AdtlComm])
    ,CCRS[FileSource] = "Activations"
    ,CCRS[GrossReturnsChargebacks] = "GROSS"
    ,Stores[Region] <> "Subagent Region"
    )

I want to include IDs 1245, 2306 and 1004 in the calculation but they are part of "Subagent Region". Is there a way to include them but still filter Region <> "Subagent Region"? 

[Greg_Deckler]

@rcss Maybe:

GADeviceBaseCommssions = 
CALCULATE
  SUMX(CCRS, CCRS[Commission] + CCRS[AdtlComm]),
  FILTER(
    'CCRS',
    'CCRS'[ID] IN { 1245, 2306, 1004 } || 
    'CCRS'[FileSource] = "Activations" && 'CCRS'[GrossReturnsChargebacks] = "GROSS" && 
    'Stores'[Region] <> "Subagent Region"
  )
)

or

GADeviceBaseCommssions = 
VAR __Table = 
  FILTER(
    'CCRS',
    'CCRS'[ID] IN { 1245, 2306, 1004 } || 
    'CCRS'[FileSource] = "Activations" && 'CCRS'[GrossReturnsChargebacks] = "GROSS" && 
    'CCRS'[Region] <> "Subagent Region"
  )
VAR __Result = SUMX(__Table, CCRS[Commission] + CCRS[AdtlComm])
RETURN
__Result

[rcss · Accepted solution]

Thank you @Greg_Deckler . You gave me idea for my calculation. This one works for me and I get the right calculation.

GADeviceBaseCommssions = 
CALCULATE(SUMX(CCRS, CCRS[Commission] + CCRS[AdtlComm])
    ,CCRS[FileSource] = "Activations"
    ,CCRS[GrossReturnsChargebacks] = "GROSS"
    ,Stores[Region] <> "Subagent Region" || Stores[ID] IN {1245, 2306, 1004}
    )