Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
the
Frequent Visitor

how to separate a measure with two variable and add it with another measure with a similar variable

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? 
the_0-1674687641147.png

 




2 REPLIES 2
the
Frequent Visitor

Well, it shows this way but still I want to show the cumulative value of the Upgrade and the Upgrade that is included in the Extension.

the_0-1674715844780.png

amitchandak
Super User
Super User

@the , For that, you can use clustered column bar

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.