Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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!
Hi @Hawkeye,
Can you share the file or a dummy sample?
Best Regards,
Dale
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?
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |