'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Count Tickets and Calculate SLA Percentages in Power BI
Question details
The user wants to group support tickets by Priority, count the total number of tickets, and calculate the percentage of tickets that met the SLA (marked as 'No' under SLA Breached) in a Power BI table visual.
- Product
- Microsoft Power BI
- Device & OS
- not provided
- Scenario
- Creating helpdesk or IT service management reports to analyze SLA compliance rates.
- Observed behavior
- Calculating the total rows and conditional percentage using DAX and displaying the aggregated metrics in a table visualization.
Ensure your Power BI data model includes a table with distinct 'Priority' and 'SLA Breached' columns, and verify that the 'SLA Breached' values are consistently formatted (e.g., exactly 'Yes' and 'No').
Use DAX Measures to Count Tickets and Determine SLA Compliance
Creating custom DAX measures is the most dynamic way to calculate ticket totals and conditional percentages for your Power BI visuals.
By using the COUNTROWS and DIVIDE functions combined with CALCULATE, you can dynamically filter data to find the exact percentage of tickets that did not breach the SLA. This allows the metrics to recalculate automatically if you add date or department slicers.
Navigate to the Data pane, right-click your 'Tickets' table, and select 'New measure'. Enter the formula: Tickets = COUNTROWS('Tickets') to count the total volume of tickets.
Create another new measure for the percentage. Enter the formula: SLA Compliance % = DIVIDE(CALCULATE(COUNTROWS('Tickets'), 'Tickets'[SLA Breached] = "No"), COUNTROWS('Tickets')).
Select your new 'SLA Compliance %' measure in the Data pane. Open the 'Measure tools' tab on the top ribbon and click the '%' icon to format the decimal value as a percentage.
Drag a 'Table' or 'Matrix' visual onto your report canvas. Add your 'Priority' column, followed by the 'Tickets' measure and the 'SLA Compliance %' measure to the Columns well to complete the grouping.
Analyze Support Data with WPS Office
While Power BI is excellent for complex enterprise dashboards, many ticket analysis and SLA calculation tasks can be done quickly and easily using spreadsheets. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office for all your data reporting needs, allowing you to build pivot tables and charts without writing DAX code.
Frequently Asked Questions
What is the best DAX function to count rows in a Power BI table?
The COUNTROWS function is highly recommended over COUNT because it counts every row in the specified table, even if some columns contain blank values. This ensures an accurate total ticket count regardless of missing data.
Why is my SLA Compliance percentage showing as a blank or returning an error?
This usually happens if the denominator in your calculation is zero or if there are spelling mismatches (e.g., your data contains 'False' instead of 'No' for SLA Breached). Using the DIVIDE function safely handles divide-by-zero errors by returning a blank rather than breaking your visual.
Can I filter the SLA compliance metric by date range?
Yes. Because you built the SLA calculation using DAX measures, you can safely add a Date slicer to your Power BI report canvas. The CALCULATE and COUNTROWS functions will automatically adapt and recalculate based on the filtered date range.
