Forum Discussion

annapurna's avatar
annapurna
Helper I
8 years ago
Solved

dax expression

hi,

i am new to power bi.can any one help me how to calculate sumof sales with two regions(east and west) using dax formula?

thanks in advance

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    Hi annapurna

     

    Try this

     

    =
    CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )