Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to split up this measure?

Hello Community  -  I need to break apart this measure and effectively look at Standard SKUs and Custom SKUs separately.     = SUMX(FILTER('Flu_Shipped Query',('Flu_Shipped Query'[DateShipped]>DAT...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Maybe:

    Measure =
  VAR __Standard = SUMX(FILTER('Flu_Shipped Query',('Flu_Shipped Query'[DateShipped]>DATE(2019,09,01) && 'Flu_Shipped Query'[SKU Types]="Standard SKUs")),[ERP Quantity Shipped2])
  VAR __Custom = SUMX(FILTER('Flu_Shipped Query',('Flu_Shipped Query'[DateShipped]>DATE(2019,09,01) && 'Flu_Shipped Query'[SKU Types] = "Custom SKUs" = "PSUs" ),[ERP Quantity Shipped2])
RETURN
  __Standard + __Custom
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous Maybe:

Measure =
  VAR __Standard = SUMX(FILTER('Flu_Shipped Query',('Flu_Shipped Query'[DateShipped]>DATE(2019,09,01) && 'Flu_Shipped Query'[SKU Types]="Standard SKUs")),[ERP Quantity Shipped2])
  VAR __Custom = SUMX(FILTER('Flu_Shipped Query',('Flu_Shipped Query'[DateShipped]>DATE(2019,09,01) && 'Flu_Shipped Query'[SKU Types] = "Custom SKUs" = "PSUs" ),[ERP Quantity Shipped2])
RETURN
  __Standard + __Custom