Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

DAX calculation

I have below excel wherei need to calculated total count and result. if 2 or more record breach then it will be failed. and if time crosses 99 (only in True case) then it will be failed. Priority...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    pls try this

     

    Measure =
    VAR _count=CALCULATE(COUNTROWS('Table'),'Table'[SLA breach]=true())
    VAR _time=sumx(FILTER('Table','Table'[SLA breach]=true()),'Table'[Duration in sec])
    return if(_count>=2 ||_time>99,FALSE(),TRUE())
     
    one more question , why the ticket no for P1 is 3?
     
     
    pls see the attachment below
     
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

what do you mean by 2 or more record breach?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

It means 2 or more ticket breached ( SLA breach will be True) for a single type. for above example its P2, where breach count is 2 as both are True

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    Anonymous 

    pls try this

     

    Measure =
    VAR _count=CALCULATE(COUNTROWS('Table'),'Table'[SLA breach]=true())
    VAR _time=sumx(FILTER('Table','Table'[SLA breach]=true()),'Table'[Duration in sec])
    return if(_count>=2 ||_time>99,FALSE(),TRUE())
     
    one more question , why the ticket no for P1 is 3?
     
     
    pls see the attachment below
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I think its my typo mistake. I will check this solution. Thanks for your help

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        2 years ago

        you are welcome