Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have OLAP source file and in that file, I want to have the sum of the particular item group.
e.g. there are many item groups like 72absc, 72dmap, 40abds, 23asrt and there is sales value for these group.
I need sum of values only for 72dmap item group.
Kindly help.
Solved! Go to Solution.
Hi @AtulSutar ,
Try a measure like this:
_72dmapSales =
CALCULATE(
SUM(yourTable[Sales]),
yourTable[Item Group] = "72dmap"
)
Pete
Proud to be a Datanaut!
Hi @AtulSutar ,
Try a measure like this:
_72dmapSales =
CALCULATE(
SUM(yourTable[Sales]),
yourTable[Item Group] = "72dmap"
)
Pete
Proud to be a Datanaut!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 9 | |
| 8 | |
| 8 |