I’m not sure which is the best approach here, I’m guessing a Switch Statement but I may be wrong also not sure if I should do it as a measure or as a calculated column. I’m guessing a measure.
Anyway I’m doing testing at work and would like to create a little Power BI Dashboard showing how devices passed and failed. I’m able to do that already pretty well. What I would like to do now is if a device has failed in any area at all anywhere it be classified as a fail. We do a multiple set of tests up to about 30. So when I put this together it’s going to be a pretty long measure I’m guessing. I’ve put together some example data showing 4 tests not 30 with an example of the finished result I’m expecting. What I’m looking for is a measure that will fill in the last column for me “Overall Test Result”
Any fail in any test should result in a fail in the Overall Test Result Field.
|Test Persons Name||Date||Test 1||Test 2||Test 3||Test 4||Overall Test Result|
Example Data.xlsx (15.6 KB)
Thanks in advance