Forum Discussion
Dynamic SUM Calculation using "Not Selected" Values and Percentile boundaries
I have a data set in the attached format with over 22,000 rows WorkOrderNumber PartNumber EmployeeFullName WorkOrderQuantity ClockedHours ClockedHoursPerUnit PercentWork Performance Wo...
Unfortunately, I was not able to resolve the issue. I decided to calculate a static IQR partitioned by the part number in SQL and created a filter to identify the rows that are within the limits of the dataset by P/N. Then I used this as a filter in a measure in addition to the not selectedvalues and P/N filters.
Unfortunately, I was not able to resolve the issue. I decided to calculate a static IQR partitioned by the part number in SQL and created a filter to identify the rows that are within the limits of the dataset by P/N. Then I used this as a filter in a measure in addition to the not selectedvalues and P/N filters.