Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Percentage of grand total

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 dayswfwf.JPG

1 ACCEPTED 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:

reply007.png

 

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

9 REPLIES 9
ZunzunUOC
Resolver III
Resolver III

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%

 

Anonymous
Not applicable

@ZunzunUOC yes basically but then i need to make it cumulative afterwards

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:

reply007.png

 

Best Regards,
Miguel

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

@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

 

Capture.JPG

Care, you need to use brackets:

 

reply012.png

Anonymous
Not applicable

@ZunzunUOC Still the same issue

 

sCFsf.JPG

Ok, delete 100 on your code please. If you use % format, not need to multiply per 100

Anonymous
Not applicable

@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 formulawefwefwef.JPG

This is a rounded number, you can add decimals and solve.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.