Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm hoping to get some help with this problem. I have sales regions where we calculate gross and net revenues using measures. We then also apply a sales degradation percentage on the net revenue. I can apply a percentage degradation across all of the reps but I would like to be able to apply a 5% degradation to North, South and West and a 2% specifically to East.
Region | Gross Revenue | Net Revenue | After Degradation |
North | 120000 | 112000 | 106400 |
South | 180000 | 108000 | 102600 |
East | 240000 | 202000 | 191900 |
West | 110000 | 98000 | 93100 |
Any ideas how this would be possible?
Thank you.
Solved! Go to Solution.
Hi @Anonymous ,
If the "After Degradation" is a column, you can use like this:
After Degradation = 'Table'[Net Revenue]*(1-SWITCH('Table'[Region],"North",0.05,"South",0.05,"West",0.05,"East";0.02,0))
If you need a mesasure, I recomend you create a table Region (if you haven't done) and add a column 'Degradation %'. So the measure for 'After Degradation' will be = Net Revenue*(1-[Degradation %])
Hi,
Create a 2 columns Table with Region in column1 and Degratation % in column 2. Let's call this Table, Table2. Create a relationship from the Region column in Table1 to the Region column in Table2. To your visual, drag Region from Table2. Write this measure and drag it to your visual
=[Net Revenue]*(SUM(Table2[Degradation %])
Hope this helps.
Thank you both! Both options worked for me. I went with the Region table with degradation % values.
Regards.
You are welcome.
Hi,
Create a 2 columns Table with Region in column1 and Degratation % in column 2. Let's call this Table, Table2. Create a relationship from the Region column in Table1 to the Region column in Table2. To your visual, drag Region from Table2. Write this measure and drag it to your visual
=[Net Revenue]*(SUM(Table2[Degradation %])
Hope this helps.
Hi @Anonymous ,
If the "After Degradation" is a column, you can use like this:
After Degradation = 'Table'[Net Revenue]*(1-SWITCH('Table'[Region],"North",0.05,"South",0.05,"West",0.05,"East";0.02,0))
If you need a mesasure, I recomend you create a table Region (if you haven't done) and add a column 'Degradation %'. So the measure for 'After Degradation' will be = Net Revenue*(1-[Degradation %])
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |