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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
geeklarokcmie
Helper II
Helper II

Calculate percentage based on the area

Hello experts,

 

I'm looking for a measure that calculates a percentage based on the total of all the money spent divided by sum of money spent in each area.

AreaSum of money spentPercentage based on total by area
BO10,9353.090992227
FA79242.67676768
IA180161.876110124
IT40578.33127927
Total33,800 

 

Thank you

 

1 ACCEPTED SOLUTION

Hi @geeklarokcmie 

 

Would a measure like this help?

Pct = 
    DIVIDE(
        SUM( 'Table'[Sum of money spent] ),
        CALCULATE(
            SUM('Table'[Sum of money spent] ),
            ALL( 'Table' )
        )
    )

View solution in original post

4 REPLIES 4
rajendraongole1
Community Champion
Community Champion

Hi @geeklarokcmie - First, create a measure to calculate the total amount spent.

 

Eg: TotalAmountSpent = SUM(SpendingData[some of amount spent])

create an one more measure to calculate the percentage of money spent in each area

 

PercentageSpentInArea =
DIVIDE(
SUM(SpendingData[Amount]),
[TotalAmountSpent],
0
)

 

use the above measure in your table chart and see the values will work as per expectations.

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Im getting all the percentage values as 100.00% using your DAX measure

Hi @geeklarokcmie 

 

Would a measure like this help?

Pct = 
    DIVIDE(
        SUM( 'Table'[Sum of money spent] ),
        CALCULATE(
            SUM('Table'[Sum of money spent] ),
            ALL( 'Table' )
        )
    )

This worked perfectly. Thank you 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors