topic Re: Need a Dax command that will show how many devices were over/under 90% in DAX Commands and Tips

Need a Dax command that will show how many devices were over/under 90%

roehler — Thu, 07 Aug 2025 15:01:53 GMT

This data shows how many sterilzation devices we have, and tracks how many times the daily log was filled out. Ideally, all devices should be over 90%, but I also want to show how many are below 90%, and I'm struggling with the DAX command to do this.

Here's the one I'm working on. It shows something, but it's not the right number:

Above90 = COUNTROWS(FILTER('Den Daily Maintenance', 'Den Daily Maintenance'[Percentage] >= FORMAT(.90, "0.00")))

Here's a link to my pbix in case it's helpful to understand the context:
https://drive.google.com/file/d/19L35iBsaLayDxqk9cMQEPw-zAzbt4H9g/view?usp=drive_link

Re: Need a Dax command that will show how many devices were over/under 90%

Greg_Deckler — Thu, 07 Aug 2025 15:13:42 GMT

roehler The Percentage column should NOT be text, make sure that it is a decimal number and then just compare to .9, no FORMAT. FORMAT switch it to text and you almost certainly don't want that.

Re: Need a Dax command that will show how many devices were over/under 90%

MohamedFowzan1 — Thu, 07 Aug 2025 15:17:20 GMT

Hi roehler

Could you try this:

Above90 = COUNTROWS(FILTER('Den Daily Maintenance', 'Den Daily Maintenance'[Percentage] >= 0.9)) Below90 = COUNTROWS(FILTER('Den Daily Maintenance', 'Den Daily Maintenance'[Percentage] < 0.9))

Re: Need a Dax command that will show how many devices were over/under 90%

V-yubandi-msft — Fri, 08 Aug 2025 05:50:43 GMT

Hi roehler ,

I have attached the pbix file for your review. The percentage values are displayed accurately for each location for Q2 2025 and Q3 2025. Devices meeting the 90% compliance threshold are clearly indicated, as are those that fall below it.

Based on the matrix, my DAX measures (Devices_Above_90 and Devices_Below_90)

should show: 5 devices at or above 90% and 5 devices below 90%.

FYI:

It appears your logic is working as expected.

Regards,
Yugandhar.

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Tue, 12 Aug 2025 14:21:17 GMT

Thanks, but that's not exactly what I'm looking for. You created as simple table, then applied a DAX command (which doesn't seem to work in my table).

I need to show the number of devices over/under 90%, something like this:

Q2 2025

Boise 36th Dental

Above 90% 2

Below 90% 0

Caldwell Dental

Above 90% 1

Below 90% 3

Here's the reference data:

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Mon, 11 Aug 2025 14:52:50 GMT

I tried them, get an error when loading.

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Tue, 12 Aug 2025 13:46:39 GMT

At least answers part of my question, Thank you.

Re: Need a Dax command that will show how many devices were over/under 90%

Rupak_bi — Wed, 13 Aug 2025 08:01:33 GMT

hi roehler ,

hope below result meets your expectation

attaching the PBIX with two calculated column that I Modified.

Let me know if this solves your ask or not. If yes, accept as solution...

Re: Need a Dax command that will show how many devices were over/under 90%

V-yubandi-msft — Wed, 13 Aug 2025 08:49:03 GMT

Hi roehler ,

I’ve set up the calculation (using sample data) so the matrix now shows the number of devices above and below 90% compliance for each location and quarter.

For example, in Q2 2025
Caldwell Dental → Above 90% = 1, Below 90% = 3

This matches the breakdown you shared earlier. I’ve attached the PBIX file for reference feel free to review it when you have a moment.

Hope this helps.

Regards,
Yugandhar

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Wed, 13 Aug 2025 15:27:52 GMT

Amazing! Thanks for your help.

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Wed, 13 Aug 2025 19:28:29 GMT

Rupak_bi Would it be possible to see all devices so you saw All devices over 90% and under 90%? I tried removing the devices field, but it doesn't seem to be correct.

Re: Need a Dax command that will show how many devices were over/under 90%

Rupak_bi — Thu, 14 Aug 2025 06:16:26 GMT

Hi roehler ,

I am unable to understant the ask. however, if you are trying to see the name of the devices, you can drag te device name in the row. See below. If you are asking something else, plz explain. a pic of desired output will be helpfull.

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Thu, 14 Aug 2025 13:48:02 GMT

I like just summary with only the Above/Below 90% count for each quarter:

Q2 2025

Above 90% 15

Below 90% 9

Re: Need a Dax command that will show how many devices were over/under 90%

Rupak_bi — Sat, 16 Aug 2025 06:50:14 GMT

Attaching modified PBIX

Re: Need a Dax command that will show how many devices were over/under 90%

roehler — Mon, 18 Aug 2025 15:09:50 GMT

You're amazing. Thank you.