Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am very new in PowerBI. and I need to find Resolution %. So in excel I usually do, (Resolved tickets / (total tickets - Scheduled tickets).
Please help.
Mohit
Solved! Go to Solution.
so you need to build the three interim measures you need
Resolved tickets / (total tickets - Scheduled tickets
Something like this. I don't know the logic you use to count the tickets, but here is one way (assuming each row is a ticket)
Resolved tickets = calculate(countrows(ticketTable),Pending="Resolved")
You will need to provide more Information. Please share your data structure, table names, columns etc.
I have huge data in which there are some ticket's status is Scheduled (Mentioned in column name 'Pending'). I have one column where mention ticket is resolved or open status as well. so I need to find Resolution % and I use Formula to find it in excel is - (Resolved tickets / (total tickets - Scheduled tickets). So in excel I usually do - (Resolved tickets[2500] / (total tickets[3000] - Scheduled tickets[200]). How can I find in PowerBI.
so you need to build the three interim measures you need
Resolved tickets / (total tickets - Scheduled tickets
Something like this. I don't know the logic you use to count the tickets, but here is one way (assuming each row is a ticket)
Resolved tickets = calculate(countrows(ticketTable),Pending="Resolved")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |