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]) ...
  • 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}
    )
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}
    )