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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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).




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

Frequent Visitor

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

Percentage = [Formula Count] / [Total Produced]

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors