Forum Discussion

mfminor's avatar
mfminor
Helper I
9 years ago

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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

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

    Percentage = [Formula Count] / [Total Produced]

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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