Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello Community - I need to break apart this measure and effectively look at Standard SKUs and Custom SKUs separately.
Solved! Go to Solution.
@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
@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