Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Measure: Sum of values by each category in Percentage

I'm new to Power BI/Dax in general, and I need to create measures  as below:


1- calculate "Estimated Total Cost" by each "Fls Strategy Theme Name"  but I need the value as Percentage %

2- calculate "Estimated Total Cost" by each "Fls Strategy Theme Name"  but I need the value as Percentage % but here I need to make a filter by Pum Duration.

Thanks in advance





multiply the measure by .01

View solution in original post

Super User
Super User

Please provide sanitized sample data that fully covers your issue. I cannot help you without usable sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

Thanks I added a measure calculating the % of ETC but here I need to change the percentage formate to be as 42% not 42000% any idea how to change it please?




multiply the measure by .01

perfect It works thanks 🙂

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.