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.
below is the following data i have i am looking to do a percentage of grand total based on the below data. So for number of days = 1 and the count being 374 what is this as of a percentage of the grand total. After i will then need to make this cummulative over numver of days
Solved! Go to Solution.
Ok, here you are, I think this is you need:
Create 2 calculated columns:
perc = ('PERCENT'[COUNT]/SUM('PERCENT'[COUNT]))*100 CumPerc = CALCULATE(SUM('PERCENT'[perc]);FILTER('PERCENT';'PERCENT'[DAY]<=EARLIER('PERCENT'[DAY])))
Results:
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @Anonymous , I have no clear what you need.
Is this your goal?
day count %
1 30 30%
2 10 10%
3 45 45%
4 15 15%
Ok, here you are, I think this is you need:
Create 2 calculated columns:
perc = ('PERCENT'[COUNT]/SUM('PERCENT'[COUNT]))*100 CumPerc = CALCULATE(SUM('PERCENT'[perc]);FILTER('PERCENT';'PERCENT'[DAY]<=EARLIER('PERCENT'[DAY])))
Results:
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ZunzunUOC thanky ou for your reply have tried the 1st column but am getting % over 100 which obviously i shouldnt any ideas screen shot attached
Care, you need to use brackets:
Ok, delete 100 on your code please. If you use % format, not need to multiply per 100
@ZunzunUOC Sorry still not working i know the total is 6700 so the attached numbers are deff wrong that i am getting when using your formula
This is a rounded number, you can add decimals and solve.
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |