Forum Discussion
Anonymous
4 years agoNot applicable
Cumulative %
Hi Can someone please help me to achieve the "cumulative %" measure based on the current displayed data. If possible please attached the Dax Code with an example. Also please adv...
- 4 years ago
Cumul % = var cr = sum('Sales Table'[Qty]) var s = summarize(allselected('Sales Table'),'Sales Table'[Store],"q",sum('Sales Table'[Qty])) var t = filter(s,[q]>=cr) return divide(sumx(t,[q]),sumx(s,[q]))Note that you have ties in your data so the result is a bit ugly.