cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## 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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted Super User VI

## Re: Power BI DAX

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

Proud to be a Super User!

4 REPLIES 4
Highlighted Super User IX

## Re: Power BI DAX

@rmauldin , 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)])))

Proud to be a Super User!

Highlighted
Frequent Visitor

## Re: Power BI DAX

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. Highlighted Super User VI

## Re: Power BI DAX

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

Proud to be a Super User!

Highlighted Community Support

## Re: Power BI DAX

If the problem is still there, could you share any sample data?

Best Regards

Maggie  