Create a Measure to show the how many records meet a criteria

[Anonymous]

Hi all,

I think this should be simple, but I just can't quite grasp how it should be done. I'm trying to create a measure in a visualisation based on the following:

a) How many Resolved records match a Category

b) By using Duration, how many of "a)" took longer than 3600 seconds to complete

The result would read as, for example, "24 out of 150" to identify how many of a certain type of case failed a KPI. 

Thank you in advance...

[v-ljerr-msft]

Hi @Anonymous,

Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue?

It's better to just share a dummy pbix file. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Anonymous]

Hi @v-ljerr-msft,

Thanks for the response. The original Power BI desktop file is a bit unweildy to cut down, so I've created a very small sample instead, which I think ably demonstrates what I'm working with. 

https://1drv.ms/u/s!AM8mEe0nTNJehyY

The first visualization displays how many of the cases are for resetting a password:

Count of Record

State is Resolved or Closed

Category is Administration Reset Password

The second visualization is a copy of the first, further filtered to find out how many were completed in under 10 minutes:

Count of Record

State is Resolved or Closed

Category is Administration Reset Password

Duration (in seconds) is less than 601

What I would like is turn this into a Measure, so that I can use it in a further calculation as a percentage. For now, just being able to display on one line would useful (for example, “18 out of 23 Password Requests were completed in under 10 minutes”).

Regards,

Jon