User Profile
roehler
Helper I
Joined 1 year ago
User Widgets
Contributions
Re: Need a Dax command that will show how many devices were over/under 90%
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:2.3KViews0likes1CommentNeed a Dax command that will show how many devices were over/under 90%
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_linkSolved2.4KViews0likes14CommentsRe: Help with NetworkDays column
I realized, it's showing the totals in the Device row and the Location row. I went into the settings, and removed the totals for the location row, now it looks like this: Now it shows a row only for the device, and not the totals for the location, which is fine. I just don't see how it's calculating the working days. There are 9 rows (X 62, should be 558) showing the working days, but its totaling to 434.1.1KViews0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.