I have the below Measure which works initially, but when I sort the vwBIDimRepairPriority table within PBI the measure breaks and every percentage goes to 100%.
Can anyone see why this would be the case and what I’m doing wrong?
Percentage (Table 1) = IF (
ISFILTERED ( vwBIDimDates[FYShortMonth] ) || SELECTEDVALUE(vwBIDimRepairPriority[RepairPriorityReportDescription]) = "Vacant/Void's" || SELECTEDVALUE(vwBIDimRepairPriority[RepairPriorityReportDescription]) = "Recalls",
BLANK (),
DIVIDE (
COUNT(vwBIFactWorksOrder[OrderID]),
CALCULATE ( COUNT(vwBIFactWorksOrder[OrderID]), ALL (vwBIDimRepairPriority[RepairPriorityReportDescription]), vwBIDimRepairPriority[RepairPriorityReportDescription] <> "Vacant/Void's", vwBIDimRepairPriority[RepairPriorityReportDescription] <> "Recalls", vwBIDimRepairPriority[RepairPriorityReportDescription] <> "Routine - 28 day"
)
))