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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
mfminor
Helper I
Helper I

Percentage Calculation

Trying to create a percentage based on two different  fields depending on which model, how many returns processed / total units produced. I made some attempts that did not work but the very basic idea of what I need would be Formula count / total produced. The measure for Formula Count is shown in the picture. I also know that some Total Produced values are blank. I am pretty new to Power BI so hopefully this isn't something too obvious. The reason it has not worked for me so far is that there are multiple values where PowerBI expects one value to be present (the Total Produced column).

 

 

ced.percentquestion.png

2 REPLIES 2
Anonymous
Not applicable

I think this can help.

 

Always use "/Calculate AllSelected" to get percentages, for me is the best way.

and the "if isblank" fixes the problem with lines without values.

 

 

Percentage = if( Isblank(
Counta(AviationTable[Unit Description])) ;0 ;Counta(AviationTable[Unit Description]) /CALCULATE(Counta(AviationTable[Unit Description]);AllSelected())

I Hope to have helped

Anonymous
Not applicable

Im not an expert at all, but did you try:

Percentage = [Formula Count] / [Total Produced]

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.