Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hi All
I have some difficulty having the percentage of the total sales for top customers.
The total sale is 16,159,000
For example, Top 1 customer should show 27.3%(this is calculated manually) instead of 49.07%(Power BI show value as percentage of 4405490/8978819)
How can I get the list of % in the third column? (sales number for individual customers/ total sales for the period-different monthes)
The total sales will change by month, I cannot use an unchanged amount to realize the function. It works when I click the whole year, but it does not work for the individual month when your total sales do not change with different months.
Solved! Go to Solution.
Hi, @WENBOJIANG
You can try the following methods.
Sample data:
Measure:
Sales 2021 = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),[Year]=2021&&[Type]=SELECTEDVALUE('Table'[Type])))
2021 % of total sales =
Var _total=CALCULATE(SUM('Table'[Sales]),ALL('Table'))
return
DIVIDE([Sales 2021],_total)
Is this the result you expect? If not, please provide more details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @WENBOJIANG
You can try the following methods.
Sample data:
Measure:
Sales 2021 = CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),[Year]=2021&&[Type]=SELECTEDVALUE('Table'[Type])))
2021 % of total sales =
Var _total=CALCULATE(SUM('Table'[Sales]),ALL('Table'))
return
DIVIDE([Sales 2021],_total)
Is this the result you expect? If not, please provide more details.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
68 | |
67 | |
41 | |
39 |
User | Count |
---|---|
48 | |
44 | |
29 | |
28 | |
28 |