Forum Discussion
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]>DATE(2019,09,01) && 'Flu_Shipped Query'[SKU Types]="Standard SKUs") || 'Flu_Shipped Query'[SKU Types] = "Custom SKUs" = "PSUs" ),[ERP Quantity Shipped2])
I want the sum of each (erp quantity) independently, with the ability to set different a different date for each.
I want the sum of each (erp quantity) independently, with the ability to set different a different date for each.
My thinking was to split them up into VAR statements...one for standard, and one for custom. Then the RETURN value would be the sum of the two variables. Any guidance how to do this is appreciated.
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
1 Reply
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