Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.