Forum Discussion
annapurna
Helper I
Helper Idax 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_Muhammad
Community Champion
Hi annapurna
Try this
= CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )