Adjust column numbers with a measure

[hidenseek9]

Hello Power BI Community,

I have a question on how to adjust column figures at the same rate to match the total numbers to a specific number. 

Sample Data

I have a data such as below. 

The total number on columns are 6,664, 6,713, and 5,835 respectively.

I would like to adjust the total to 8,000, 8,000 and 7,000 respectively. 

So what I would like to do is for Power BI to calculate the % increase/decrease 

and apply the rate automatically to all rows. 

Expected outcome is shown below. 

How can I create a measure to calculate adjusted figures?

Many thanks,

H

[Cmcmahan]

Sure. You want to weight the figures by whatever value.  How does PowerBI know the target number?  Is it always going to be 8000, 8000, 6000?

Also, the sample data file you shared is unavailable to people outside your organization. 

Assuming you have a measure like [Material Target] that returned the 8000 value (and one for Industrial & Logistics), you could do it like this:

% adjustment = DIVIDE( [Material Target], CALCULATE(SUM('Products'[Material])), ALL('Products') )

And then for your data column, replace the table values with a measure like:

Weighted Material = SUM('Products'[Material]) * [% adjustment]

[hidenseek9]

@Cmcmahan 

Thank you for your reply.

Target number will constantly change.

I have modified the access authority, so please find below data.

Sample Data

I do not have a measure to set the target value.

How can I create a measure that I can put target value directly?

What is the best way to approach?

Thanks,

H

[Cmcmahan · Accepted solution]

Well that depends. How is the target calculated in the first place?  If it's just arbitrary, then you'll have to set up a new data table that holds the target.

[hidenseek9]

@Cmcmahan 

Yes it is arbitrary. It changes constantly.

I guess I will try to create a measure to set the target.

Thanks for the help.

H