Forum Discussion

muhammedaslam02's avatar
muhammedaslam02
Frequent Visitor
3 years ago
Solved

line and clustered chart

      I have a line and clustered column chart. Can anyone help me as I want to add the below values to the line y axis 1)count of SLA Vilotaed per month 2)Count of "user1" per month ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi muhammedaslam02 

     

    Here are my measures. Hope they would be helpful. 

    User1 Count =
CALCULATE (
    COUNT ( Tickets[Ticket ID] ),
    FILTER (
        Tickets,
        Tickets[Created time] <= MAX ( Dim_Date[Date] )
            && (
                Tickets[Closed time] >= MIN ( Dim_Date[Date] )
                    || ISBLANK ( Tickets[Closed time] )
            )
            && Tickets[User] = "USER1"
    )
)
    SLA Violated Count = 
CALCULATE (
    COUNT ( Tickets[Ticket ID] ),
    FILTER (
        Tickets,
        Tickets[Created time] <= MAX ( Dim_Date[Date] )
            && (
                Tickets[Closed time] >= MIN ( Dim_Date[Date] )
                    || ISBLANK ( Tickets[Closed time] )
            )
            && Tickets[Resolution status] = "SLA Violated"
    )
)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
3 years ago

Hi muhammedaslam02 

 

Here are my measures. Hope they would be helpful. 

User1 Count =
CALCULATE (
    COUNT ( Tickets[Ticket ID] ),
    FILTER (
        Tickets,
        Tickets[Created time] <= MAX ( Dim_Date[Date] )
            && (
                Tickets[Closed time] >= MIN ( Dim_Date[Date] )
                    || ISBLANK ( Tickets[Closed time] )
            )
            && Tickets[User] = "USER1"
    )
)
SLA Violated Count = 
CALCULATE (
    COUNT ( Tickets[Ticket ID] ),
    FILTER (
        Tickets,
        Tickets[Created time] <= MAX ( Dim_Date[Date] )
            && (
                Tickets[Closed time] >= MIN ( Dim_Date[Date] )
                    || ISBLANK ( Tickets[Closed time] )
            )
            && Tickets[Resolution status] = "SLA Violated"
    )
)

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.