Forum Discussion
Anonymous
3 years agoNot applicable
Cumulative Sum Measure
Hi, I've made below measure for Cumulative Sales. However I want it slightly different so that when I select for example Months 7, 8 and 9, it only shows cumulative sales as from Month 7 on. So, ...
- 3 years ago
Anonymous Should be able to use something along the lines of IF(COUNTROWS(ALLSELECTED('Table')) = 1, <net sales goes here>, <cumulative measure goes here>)
Greg_Deckler
3 years agoCommunity Champion
Anonymous Try using ALLSELECTED vs. ALL