Sum with two standards

Question

Hi,&nbsp;I have the following problem:&nbsp;FileTournumberPriceLo/La1149071500LA1149071500LO2149071230LA2149071230LO3149072600LA3149072600LO1149072480LA1149072480LO4149073250LA4149073250LO&nbsp;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.&nbsp;The filenumbers and tournumbers are alot of different numbers.&nbsp;I want to create this:&nbsp;FileTournumberTotal price of tour1149071730214907173031490721100114907211004149073250&nbsp;This I have to use to create a measurement dived the costs based on the file prices.&nbsp;I hope it makes a bit sense, sometimes it's hard to explain what you exactly mean!&nbsp;Kind regards,&nbsp;Tim Wijnen

anonymous · Accepted Answer

Hi&nbsp;Wiene24&nbsp;,
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"
            &amp;&amp; [Tournumber] = EARLIER ( Table[Tournumber] )
    )
)

Regards,
Xiaoxin Sheng

Forum Discussion

Sum with two standards

1 Reply

Related content

Standard gateway

Running sum

Filtering a Sum

Improper Sum with slicer

Standard or fixed Bar width

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

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