Average of count

[tebtim19]

I have a card in Power BI which is the comes from the count of all employees. But I want it to show as percentage in card is that possible?

[amitchandak]

@tebtim19 , percent of what ?

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[tebtim19]

Okay for example I put a card then add count of employees. but I want to show it as Average? 

[ibarrau]

Hi. Is there any condition for this percentage? The average you are looking for is only available in numbers and employee column is not. It's not quite clear what kind of percetage you want. I am writting down a classic formula for a measure to calculate the % total general of employees in the dataset.

% Employees =
DIVIDE(
    COUNT(Table[Employee]),
    CALCULATE( COUNT(Table[Employee]), ALL(Table) ),
    0
)

There are better ways to calculate this but I'm not sure if this is what you are looking for.

Regards, 

[tebtim19]

I tried what you told me, but I dont understand why I only get 1% in the card when I put the measure

[v-jayw-msft · Accepted solution]

Hi @tebtim19 ,

What exactly do you need? Average of count or average of percentage?

percentage = SELECTEDVALUE('Table'[count])/CALCULATE(SUM('Table'[count]),ALL('Table'))

average of percentage = AVERAGEX('Table',[percentage])

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tebtim19]

I tried to do the average of count but I only get Can't display the visual. when I put added it to the card

[FarhanAhmed]

Try Following 

Average = AVERAGEX(VALUES(Table[Manager]),[FemaleCountMeasure])

[v-jayw-msft]

Hi @tebtim19 ,

You can click "show details" to check the error message.

And what your table looks like? Better to show some sample data to us as i did above.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

This might be because of two things. One is the formatting, consider formatting the measure as % or add decimals to avoid power bi rounding up your number.

https://community.powerbi.com/t5/Desktop/Percentage-formatting-for-calculated-measures-in-table/td-p...

The other thing can be because unless you filter something you will have a 100% because the calculation is FilteredEmployees / AllEmployees

That is what I understood about the measure.

Regards,