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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gianmarco
Helper IV
Helper IV

sum order values that contains a specific item

Dear All,

i have the following table:

Order numberItemValue
1a12
1b15
2b15
2c20
3d11
3a12

 

I need the total order values of the order which contains item "a". 

So my calculated measure shall give back 50 (because it sums all values of order 1 and 3).

 

Thank you  very much

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

You can create a measure like
Value all orders = 
var orderIDs = VALUES('Table'[Order number])
return CALCULATE( SUM( 'Table'[Value]), REMOVEFILTERS('Table'), orderIDs )

View solution in original post

2 REPLIES 2
johnt75
Super User
Super User

You can create a measure like
Value all orders = 
var orderIDs = VALUES('Table'[Order number])
return CALCULATE( SUM( 'Table'[Value]), REMOVEFILTERS('Table'), orderIDs )

Exactly what I was talking about! Thank you a lot!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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