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'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 %])
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |