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
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}) |
) |
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})) |
Measure 3, (measure 1 + measure 2):
Total open Sales = [Sales Invoiced Amt_MS] + [Open Sales order Amt_MS]
As you can see Global indirect only shows Measure 1 total and does not refelct measure 2.
Help please.
Thank you.
Solved! Go to Solution.
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
Proud to be a 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
Proud to be a Super User!
User | Count |
---|---|
12 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
27 | |
19 | |
14 | |
11 | |
7 |