topic Percentage Calculation in DAX Commands and Tips

Percentage Calculation

mfminor — Thu, 17 Nov 2016 22:44:28 GMT

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.

Re: Percentage Calculation

Anonymous — Wed, 23 Nov 2016 19:59:45 GMT

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

Percentage = [Formula Count] / [Total Produced]

Re: Percentage Calculation

Anonymous — Thu, 01 Dec 2016 21:44:45 GMT

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