Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
80 | |
61 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |