Forum Discussion

annapurna's avatar
annapurna
Icon for Helper I rankHelper 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
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi annapurna

     

    Try this

     

    =
CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi annapurna

 

Try this

 

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