Mesure for Calculating Invoice Total Based on Order Number

DAX DAX Calculations
1

Dear Experts

Please look at the below screen-shot:

image
image810×546 16.4 KB

I need to create measure that calculate the Invoice total based on the order no as it is shown in the screen-shot, for example the sum of the order invoce total shoud be on this case = 498 , I attached a sample order table with this post.
Orders.xlsx (9.5 KB)

1 Like
2

Hi @MAAbdullah47,

Give this a go:

Inv Total = 
SUMX(
    SUMMARIZE( 'Sample', 'Sample'[Order#], 'Sample'[Order Invoice Total ] ),
    [Order Invoice Total ]
)

I hope this is helpful

3 Likes
3

Thank you @Melissa it works.

1 Like