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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Was doing the Inventory ABC analysis, and need calculate the Culmmunative Share for the ABC ,
from the online vedios they using add a column then use the below fomula:
Culmmunative share %=Calculate(Sum(Inventory[revenue share%]),
Filtera(Inventory,Inventory[revenue share%]>=
Earlier(Inventory[revenue share%])))
this one is not working for the DAX measure , only working for the culumn, but becasue the column is not working for the previous culumn when i want to calculate the revenue share as the revenue total is calculate by another table from online 365 dynamic service. So i couldnt use the column for the calcualtion.
Hope to find a way to use the DAX measure for this.
thank you if any experts have better solution for this