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 i...
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

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