Forum Discussion
annapurna
8 years agoHelper I
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
Hi annapurna
Try this
= CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )
1 Reply
- Zubair_MuhammadCommunity Champion
Hi annapurna
Try this
= CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )