Forum Discussion

Wiene24's avatar
Wiene24
Icon for Helper II rankHelper II
7 years ago
Solved

Sum with two standards

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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