Showing results against a reduced percentage?

[Hawkeye]

Hi all, 

A tricky one to explain, but I will give it a go 

I have two reports that are related, but generated from seperate systems - in the long run I will be merging them into a single form, but currently stretched for time. 

As the results are slightly related I wondered if there was a way to restrict the percentages of one result based on the value of the other.

For example - standard reports:

1st report

Taken 54%

Given 46%

2nd report then limited to 46% as it's linked to what was Given

So, figures like:

Item 1 - 50%

Item 2 - 25%

Item 3 - 25%

Become

Item 1 - 23%

Item 2 - 11.5%

Item 3 - 11.5%

I'd be happy to manually enter the percentage from the first report, but need a way of limiting the overall percentage on the 2nd.

(hope that makes sense)

Many thanks!

[Hawkeye]

This turned out to be more of a math problem than a PowerBi one. 

Essentially I needed to divide the number against the Item by the total of all the items added together, and then divide this by the percentage figure I wanted to limit the results too.

So to use my previous figures; e.g.

Taken 54%

Given 46%

2nd report then limited to 46% as it's linked to what was Given

So, figures like:

Item 1 - 100

Item 2 - 50

Item 3 - 50

Become

Item 1 - 23%

Item 2 - 11.5%

Item 3 - 11.5%

(sum being along the lines of 100/200*46)

Clearly I was having a bad day, just need to figure out how to work this in PowerBi! 

[v-jiascu-msft]

Hi @Hawkeye,

Can you share the file or a dummy sample?

Best Regards,

Dale

[jthomson]

Not entirely clear how your percentages are calculated, but you could try making a new measure that pulls in the value you need from the first report as a variable, and then multiply that by your second measure?