Forum Discussion

MadhavDholakia's avatar
MadhavDholakia
Helper I
1 year ago

Measure as Values in Matrix

Hello,   I have a data set from ITSM system with fileds including TicketID, Queue, Analyst, Type, Resolution Time in Bhrs (Minutes) and FCR (First Contact Resolution), Resolved Date.   A measure ...
Need Help
suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi MadhavDholakia 

Try this 

FCR % = 
CALCULATE(DIVIDE(
        COUNTROWS(FILTER(Tickets, [FCR] = "Yes" && [Resolution Time in Bhrs] <= 30)),
        COUNTROWS(FILTER(Tickets, [Type] = "Incident")),0
    ),
    ALL(Tickets[Queue]))
  • MadhavDholakia's avatar
    MadhavDholakia
    Helper I
    1 year ago

    thanks suparnababu8 - I am still getting the same numbers - I think there is some issue with underlying data then? Let me share sample data in some time.