Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
142 | |
112 | |
98 | |
98 | |
94 |