cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GhadaMehrez
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

 

GhadaMehrez_0-1659549206601.png

 

1 ACCEPTED SOLUTION

multiply the measure by .01

View solution in original post

4 REPLIES 4
lbendlin
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.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

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?

 

GhadaMehrez_0-1659961656748.png

 

multiply the measure by .01

perfect It works thanks 🙂

Helpful resources

Announcements
Carousel_PBI_Wave1

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 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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.