Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello I have a dataser similar to:
East | West | Total | ||||
CLIENT 1 | 130 | 150 | 280 | % of Total | ||
Current | 120 | 16% | 139 | 16% | 259 | 16% |
Past Due | 10 | 1% | 12 | 1% | 22 | 1% |
CLIENT 2 | 108 | 125 | 233 | |||
Current | 100 | 13% | 116 | 13% | 216 | 13% |
Past Due | 8 | 1% | 9 | 1% | 17 | 1% |
CLIENT 3 | 58 | 67 | 125 | |||
Current | 50 | 7% | 58 | 7% | 108 | 7% |
Past Due | 8 | 1% | 9 | 1% | 17 | 1% |
CLIENT 4 | 455 | 526 | 981 | |||
Current | 450 | 60% | 520 | 60% | 970 | 60% |
Past Due | 5 | 1% | 6 | 1% | 11 | 1% |
TOTAL | 751 | 100% | 868 | 100% | 1619 | 100%
|
As you can see when I add the column Sales Again, and then format it to show as total of column, it gives me the percentage of the whole Division East, West. Not for each client.
What I need to have is:
East | West | Total | ||||
CLIENT 1 | 130 | 150 | 280 | % of Total | ||
Current | 120 | 92% | 139 | 92% | 259 | 92% |
Past Due | 10 | 8% | 12 | 8% | 22 | 8% |
CLIENT 2 | 108 | 125 | 233 | |||
Current | 100 | 93% | 116 | 93% | 216 | 93% |
Past Due | 8 | 7% | 9 | 7% | 17 | 7% |
CLIENT 3 | 58 | 67 | 125 | |||
Current | 50 | 86% | 58 | 86% | 108 | 86% |
Past Due | 8 | 14% | 9 | 14% | 17 | 14% |
CLIENT 4 | 455 | 526 | 981 | |||
Current | 450 | 99% | 520 | 99% | 970 | 99% |
Past Due | 5 | 1% | 6 | 1% | 11 | 1% |
I tried doing a formula like this:
East | West | Total | |
CLIENT 1 | 280 | 280 | 280 |
Current | 280 | 280 | 280 |
Past Due | 280 | 280 | 280 |
CLIENT 2 | 233 | 233 | 233 |
Current | 233 | 233 | 233 |
Past Due | 233 | 233 | 233 |
CLIENT 3 | 125 | 125 | 125 |
Current | 125 | 125 | 125 |
Past Due | 125 | 125 | 125 |
CLIENT 4 | 981 | 981 | 981 |
Current | 981 | 981 | 981 |
Past Due | 981 | 981 | 981 |
The question is:
How can I make a Total By Client and By region, So then I can make a Divide of the total by this new measure to obtain the % of each client by region.
Thanks in advance
Solved! Go to Solution.
Hi @dudasucx
Please check th link
Solved: Category Percentage of Row Total - Microsoft Power BI Community
Cheers
CheenuSing
Hi,
Are Current and Past Due measures? Share the link from where i can download your PBI file.
There is only one measure, there is no time intelligence involved here. I wll create a sample file to share.
Hi @dudasucx
Please check th link
Solved: Category Percentage of Row Total - Microsoft Power BI Community
Cheers
CheenuSing
I0ve already seen that post of yours, and tried it, but I was assigning a wrong variable to the AllExcept. Seeing it again gave me new light!! Thanks KUDOS!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |