This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
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
Solved! Go to Solution.
Hi @annapurna
Try this
=
CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )
Hi @annapurna
Try this
=
CALCULATE ( SUM ( TableName[Sales] ), TableName[Region] IN { "EAST", "WEST" } )
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 21 | |
| 21 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 35 | |
| 24 | |
| 20 | |
| 19 |