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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
MSM
New Member

Do not know how to add 2 measures together that have slicers

I'm a new PowerBi user, and I can't figure out how to add two measures together that are both affected by a slicer. I've tried everything I can think of, and I can never get it to add up properly, any thoughts? 

 

Desired outcome: 

I would like to add these two measures together to get a final total. 

 

Measure 1 = 

Sales Invoiced Amt_MS = CALCULATE (

    [Amount (Dr/Cr)],

    'Transaction Lines'[Type] IN { "Invoice", "Credit Memo" },

    'Transaction Lines'[Account Internal ID] IN {242, 1387,1391},    

    NOT ('Transaction Lines'[Item Internal ID] IN {6530,6531,6533,6532,30690,51765,24243,31711,57984,47371,47523,33072,24247,13447,13446,13449,13448,37149,37242,28862,168,169,29870,28978,57267,6523,47264,6525,6528,6527,6524,6526,20809,29781,29720,32162,47461,6534,47154,29782,6160,57626,6529,2505})

    )

MSM_4-1704488521090.png

 

Measure 2 = 

Open Sales Order Amt_MS =

CALCULATE(

    [Amount (Dr/Cr)],

    KEEPFILTERS('Transaction Header'[Project End Date]<=date(2024,01,31)),

    NOT 'Transaction Lines'[Status] IN {"Billed", "Cancelled", "Closed","Refunded"},

    'Transaction Lines'[Type] = "Sales Order",

    NOT ('Transaction Lines'[Item Internal ID] IN {6530,6531,6533,6532,30690,51765,24243,31711,57984,47371,47523,33072,24247,13447,13446,13449,13448,37149,37242,28862,168,169,29870,28978,57267,6523,47264,6525,6528,6527,6524,6526,20809,29781,29720,32162,47461,6534,47154,29782,6160,57626,6529,2505}))

 

 

MSM_5-1704488547782.png

 

 

 

Measure 3, (measure 1 + measure 2):
Total open Sales = [Sales Invoiced Amt_MS] + [Open Sales order Amt_MS]

MSM_6-1704488567094.png

As you can see Global indirect only shows Measure 1 total and does not refelct measure 2. 

Help please.

 

Thank you.

1 ACCEPTED SOLUTION
some_bih
Super User
Super User

Hi @MSM try measures as variable

 

Total open Sales v2 =
VAR __measure_1=
[Sales Invoiced Amt_MS] 

VAR __measure_2= [Open Sales order Amt_MS]

RETURN __measure_1+__measure_2





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






View solution in original post

1 REPLY 1
some_bih
Super User
Super User

Hi @MSM try measures as variable

 

Total open Sales v2 =
VAR __measure_1=
[Sales Invoiced Amt_MS] 

VAR __measure_2= [Open Sales order Amt_MS]

RETURN __measure_1+__measure_2





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






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.