Hi,
I'm trying to do something similar to this post (https://community.powerbi.com/t5/Desktop/Need-overall-status-based-on-individual/td-p/1143868) but with an added layer of complexity.
I have a table which looks sort of like this
Name Result
blah Pass
blah Pass
meh Pass
blah Pass
meh Fail
I want to calculate an "overall result" for each distinct "Name". So if every row where Name is "blah" has result "Pass", as above, then its overall result should be "Pass", while if there's a single "Fail" (as with "meh") then the overall result should be "Fail". I've seen a lot of similar calculations in other posts, but none which cover segregating the overall result on a per-name basis.
Right now, the data is visualized in a pivoted matrix based on the original table that looks like so
Name Pass Fail
blah 3 0
meh 1 1
I would want the end result to look like this:
Name Pass Fail Overall
blah 3 0 Pass
meh 1 1 Fail
If the actual table were organized in the DB into rows and columns like the pivoted matrix, the calculation would be doable, but that's not an option for me. Anyone have any ideas how I can get the multiple distinct overall results when all results share a single column in the table?
