Sum with two standards

[Wiene24]

Hi,

I have the following problem:

File	Tournumber	Price	Lo/La
1	149071	500	LA
1	149071	500	LO
2	149071	230	LA
2	149071	230	LO
3	149072	600	LA
3	149072	600	LO
1	149072	480	LA
1	149072	480	LO
4	149073	250	LA
4	149073	250	LO

Now I want to add a new Colomn that shows me on each row how much the total price was of the tournumber where LA/LO = "LO". I have to do it with a colomn because the report is based on orders and a order can be on multiple tours.

The filenumbers and tournumbers are alot of different numbers.

I want to create this:

File	Tournumber	Total price of tour
1	149071	730
2	149071	730
3	149072	1100
1	149072	1100
4	149073	250

This I have to use to create a measurement dived the costs based on the file prices.

I hope it makes a bit sense, sometimes it's hard to explain what you exactly mean!

Kind regards,

Tim Wijnen

[Anonymous · Accepted solution]

Hi @Wiene24 ,

You can use following calculated column formula to summarize same tour price with 'lo' status:

Total Price =
CALCULATE (
    SUM ( Table[Price] ),
    FILTER (
        ALLSELECTED ( Table ),
        [LO/LA] = "LO"
            && [Tournumber] = EARLIER ( Table[Tournumber] )
    )
)

Regards,

Xiaoxin Sheng