Hi,
I have not been able to find a way to get this to work successfully.
Lets say I have 10 jobs in the system. Each job can have different operation numbers. Most will be 10,30,40,50 for this example.
For the sake of explaining lets say 8 jobs are setup this way.
However some jobs will have an operation 20. Lets say 2 jobs are setup this way out of the 10.
I have basic data that has a row for each labor entry on the jobs. This could be 0 for a job, or 20, it depends on how involved the job was.
I have a table that has 4 columns. One directly from the table (job number) and 3 measures that show different values A, B, and C. Those have filters placed on them at a measure level. Measure A has a filter that says the operation to look at when calculating need to be = 10. B and C must have operation = 20.
What I need to do is have the first column, job number, ONLY show jobs that have operation 20 as one of its operations. To accomplish this I set a visual level filter to look for operation = 20.
This method shows the correct jobs in the table. But breaks measure A so its blank, since it cant calculate for measure 10 when the visual is filtered to be the rows that only have operation 20.
Example Data:
| Job | Operation | Total | Tested | Scrapped |
| A | 10 | 60 | 50 | 0 |
| A | 20 | 50 | 50 | 0 |
| A | 20 | 50 | 10 | 0 |
| B | 10 | 200 | 200 | 0 |
| B | 10 | 50 | 0 | 0 |
| B | 20 | 200 | 150 | 20 |
| C | 10 | 100 | 100 | 0 |
Example Result:
| Job | Total | Tested | Scrapped |
| A | 60 | 60 | 0 |
| B | 250 | 150 | 20 |
This removes job C since it does not have an operation 20 assigned to it.
Measures:
The job column comes directly from the data and is not a measure.
Total:
Right now with a visual level filter of operation = 20, the job column, Tested, and Scrapped column are correct since they all look for operation 20. The A column is not correct with the below measure since it cant get to operation 10:
Total = CALCULATE(
SUM(Test[TestQty]),
Test[Operation] = 10
)
Is there a way to write this measure so it will ignore the visual level filter, and still look for operation 10?
I tried things like removefilters, allexcept, but none seem to work correctly.
Tested:
Tested = CALCULATE(
SUM(Test[LaborQty]),
Test[Operation] = 20
)
Scrapped:
Scrapped = CALCULATE(
SUM(Test[ScrapQty]),
Test[Operation] = 20
)
I either need to adjust all measures to produce the correct result. Or adjust the total measure as described above.
Any suggestions?
