Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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, not showing values € 28.814.316,37 (Month 7), € 30.580.458,70 (Month 8), € 33.891.502,57 (Month 9) but values € 3.315.379,87 (Month 7), € 5.081.522,20 (Month 8 --> € 3.315.379,87 + € 1.766.142,33) and € 8.392.566,07 (Month 9 --> € 5.081.522,20 + € 3.311.043,87).
Does someone have an idea how to change the measure?
Solved! Go to Solution.
@DM_95 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 Thank you!
I want to use this cumulative measure in another measure as mentioned below (the idea is to switch to cumulative values (VAR _Cumulative) when more than 1 month is selected. If only 1 month is selected, it needs to show the Net Sales(=SUM(Sales[SalesAmount])). However, it does not work properly. Do you have an idea how it might work?
@DM_95 Should be able to use something along the lines of IF(COUNTROWS(ALLSELECTED('Table')) = 1, <net sales goes here>, <cumulative measure goes here>)
@DM_95 Try using ALLSELECTED vs. ALL
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |