Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |