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

[roehler]

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

[Rupak_bi · Accepted solution]

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

[Rupak_bi · Accepted solution]

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

[roehler]

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

[Rupak_bi]

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.

[roehler]

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

                     Q2 2025

Above 90%       15

Below 90%        9

[Rupak_bi · Accepted solution]

Attaching modified PBIX

[roehler]

You're amazing.  Thank you.

[roehler]

Amazing!  Thanks for your help.

[roehler]

At least answers part of my question, Thank you.

[V-yubandi-msft]

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.

[roehler]

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:

[V-yubandi-msft]

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

[MohamedFowzan1]

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))

[roehler]

I tried them, get an error when loading.

[Greg_Deckler]

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