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.
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
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.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |