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