Apply different percentage value depending on Region

[Anonymous]

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.

[mauriciosotero · Accepted 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 %])

[Anonymous]

Thank you both! Both options worked for me. I went with the Region table with degradation % values.

Regards.

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

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.

[mauriciosotero · Accepted 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 %])