I have two measures. here is
Service Orders =
VAR Variable_1 =
CALCULATE (
[Delivered Quantity],
FILTER (
'Sales Order Line Financials by Month',
'Sales Order Line Financials by Month'[Orders Received Local Currency] >= 2000
),
FILTER (
'Manufacturing Type',
'Manufacturing Type'[Manufacturing Type] = "Extension"
)
)
VAR Variable_2 =
CALCULATE (
[Delivered Quantity],
FILTER (
'Manufacturing Type',
'Manufacturing Type'[Manufacturing Type] = "Upgrade"
)
)
Return
Variable_2 + Variable_1
..........................
Small Extension Orders =
VAR var1=
CALCULATE (
[Delivered Quantity],
FILTER (
'Sales Order Line Financials by Month',
'Sales Order Line Financials by Month'[Orders Received Local Currency] < 2000
),
FILTER (
'Manufacturing Type',
'Manufacturing Type'[Manufacturing Type] = "Extension"
)
)
Return
var1
One problem I have been facing is that when I throw both measures in stacked column chart with the "Upgrade" and "Extension" orders stacked on top of each other.
From these measures how can I separate "Upgrade" orders from "Extension" orders, and show them separately in the chart in Power BI?
