Column value depicts which measure is used to generate a percentage

[FlankyPank2___]

Hi,

I'm back.. again. Sorry, I'm so close to finishing my report though!

I want to find out if we're hitting targets.  We have been given percentage targets.

I would love to just use one column to do this on my table visual.

I already have measures that give me a target total e.g.

Midlands 22 = SWITCH(SELECTEDVALUE(Data[Programme (Renamed)]),"Midlands",22

South 10 = SWITCH(SELECTEDVALUE(Data[Programme (Renamed)]),"South",10

East 14 = SWITCH(SELECTEDVALUE(Data[Programme (Renamed)]),"East",14

(I use these to plot a line on my graphs)

I'm now using the measures above to find out my percentage:

Target Percentage = [Slicer Day Count]*[Midlands 22]

What i'm looking for is to be able to use each of these measures dependant on whether another text value is in a column.

So if my column is called "Region" contains entries called "Derbyshire" I would like it to use "Midlands 22" in my Target Percentage equation. But, if the region was "Norfolk" it would use "East 14" in my target percentage equation.

So I just want one column in my table visual to show an answer dependant on what location is in "Region".  I have a maximum of 5 Locations/regions.

I really hope that makes sense!!

Thank you - i've tried lots of variations and i'm not winning.

[MFelix · Accepted solution]

Hi @FlankyPank2___ ,

Create a single measure with the following code:

Target = SWITCH(SELECTEDVALUE(Data[Programme (Renamed)]),
                  "Midlands",22
                   "South",10,
                  "East",14)

Then use the following code:

Target Percentage = [Slicer Day Count]*[Target]

[FlankyPank2___]

Thank you so much - simple.

I need to learn Dax when i've finished this project!  Thanks again

[MFelix]

Don't forget to accept the correct answer to help others.