For the time frame I've selected, I have had 43 work orders, in which, part number 307083-2 has been used 27 times, equalling a 62.79% usage rate. What DAX formula do I use to display the percentage? The current one I wrote is not working.
That doesn't seem to be what I need. If I select one time frame, it works but I want to show how the one part "% used" changes over months/years. if I select multiple months/years, the percentages are all wrong. It changes to a percentage of the entire time frame, not the % usage of the work orders in each month, each year.
Without seeing a bit more of your model, i'm not sure I can pull this off competely, but hopefully you get the idea 🙂
Total WO := COUNTROWS(WorkOrders)
Total ALL WO := CALCULATE([Total WO], ALL(WorkOrders[PartNumber]))
WO Percentage := DIVIDE([Total WO], [Total ALL WO])
That make sense? The 2nd measure it going to calc the Total WO's, but it will remove the PartNumber filters (from the part number you have on rows). It will still keep any other filters you have (say, on a date range), so it won't be the all up grand total.
This is almost perfect. Here is my problem. The "Total All WO" is only counting the "Total WO" that appear in the "WO_Line"table. I need it to count all WO, instead of just the ones that have had "PartNumber" added to them. I hope this makes since.