Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI DAX

I am trying to calculate a complaince %. The compliance is the count of number under 270. A simple calucation would be:

 

(count of durantion times under 270) / (count of duration times)

 

This is the DAX I am trying to use in a quick masure but its not working. Any suggestions

 

Measure 1 = (CALCULATE(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)]), '2020 Turn Around Times'[Turnaround Time (Minutes)]<=270))/(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)]))
 
Thanks!
Robin
General Comment
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    I think I ended up writing the same measure as you did, but it got the expected result.

     

    Pct on Time =
    CALCULATE (
    COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] ),
    '2020 Turnaround Times'[Turnaround Time (Minutes)] <= 270
    )
    / COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] )

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , for the filter you need a row context, I assumed that as call ID (Replace with the correct column)

    Try lik

    Measure 1 = (CALCULATE(COUNTX(Filter(Summarize('2020 Turn Around Times','2020 Turn Around Times'[Call ID],"_1",[Turnaround Time (Minutes)]), [_1]<=270),[_1])/(COUNT('2020 Turn Around Times'[Turnaround Time (Minutes)])))

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      That didn't work.  The correct calculation (I know because I tested it in Excel) is 55.56%. Below is a screen shot of the data I'm working with. I need to know the % of times that the minutes are less than or equal to 270.

       

      Thank you for your help

       

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        6 years ago

        I think I ended up writing the same measure as you did, but it got the expected result.

         

        Pct on Time =
        CALCULATE (
        COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] ),
        '2020 Turnaround Times'[Turnaround Time (Minutes)] <= 270
        )
        / COUNT ( '2020 Turnaround Times'[Turnaround Time (Minutes)] )

         

        If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

        Regards,

        Pat