Forum Discussion

rcss's avatar
rcss
Frequent Visitor
3 years ago
Solved

Include values that got filtered out

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"? 

  • rcss's avatar
    rcss
    3 years ago

    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}
    )

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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's avatar
      rcss
      Frequent Visitor
      3 years ago

      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}
    )