Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
Solved! Go to 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 🙂
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 🙂
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.
you just need to replace the ="true" to = true()
Without quotation marks
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?
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
86 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
110 | |
97 | |
71 | |
67 |