cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Column value depicts which measure is used to generate a percentage

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.

1 ACCEPTED SOLUTION
Super User

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]``

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

3 REPLIES 3
Super User

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]``

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Helper I

Thank you so much - simple.

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

Super User

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

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.