How to calculate percentage per month?

[Anonymous]

Hello,

We are creating a Power BI report based off a metric we have that is called FCR (First Call Resolution). It is a boolean field that uses true/false. We are looking to see how members on our team perform on this metric month to month based off a percentage. I'm relatively new to Power BI and the current setup I have just shows a bar graph visual with a count and then a pie chart to the right with a slicer if you want to see a percentage of the month. The report we plan on replacing has the percentage over each month (example below). This works but it is not ideal. I am guessing there is some sort of division formula or something similar to set this up. I have tried to look on how to create this measure but I don't know the correct terms to search for when I look. I have never created anything custom in Power BI before, I'm assuming it needs to be a new measure but I don't know the context for what needs to be done. My assumption is it needs to be some sort of division formula of true or false divided by the total but I don't know for sure.

What we have:

What we need:

[khaledHabib90 · Accepted solution]

Hi Rober,

Here is a measure by that can help you

FCRmeasure = Calculate(countrows( yourtablename ), FCR="True")/countrows( yourtablename )

You will need to update the table name with your table name

I also recommend that you first take a basics course in power bi before starting with reports

Did my reply help you solve your problem? If yes please accept it as a solution 🙂

[Anonymous]

I tried to create the measure and I think we're closer but I still get an error. This is what I have, any other ideas? I tried looking into the value and format functions the error mentions but I wasn't able to get anything working.

FCRPercent = Calculate(COUNTROWS(Data), Data[FirstCallResolution]="True")/COUNTROWS(Data)

[khaledHabib90]

you just need to replace the ="true" to = true()

Without quotation marks

[Anonymous]

That worked great, thank you. Any idea on how to get it to show as an actual percent instead of just a decimal? I tried going to the display units in the format visual pane but it looks like I don't have a percent option. The other way I found was to change the data type for the column, but since it is a measure it doesn't have it's own column. Any ideas?

[khaledHabib90]

If you click on the created measure, you will find a new tab appear on the top of powerbi window called measure tools, in the this new tab choose the data type percentage