Forum Discussion
Database design for comparing rows
Hi Benjamin_Eureka,
Is the output in your data your expected output? But as parry2k said, the data you provided lack candidate column. Would you please check for it?
If you want to filter out candidate that pass both Exam A and Exam B, please refer to the measure below:
Measure = VAR A = CALCULATE ( MAX ( 'Table'[result] ), ALLEXCEPT ( 'Table', 'Table'[candidate] ), 'Table'[exam] = "ExamA" ) VAR B = CALCULATE ( MAX ( 'Table'[result] ), ALLEXCEPT ( 'Table', 'Table'[candidate] ), 'Table'[exam] = "ExamB" ) RETURN IF ( A = "Yes" && B = "Yes", 1, 0 )If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Benjamin_Eureka hey could you please post the sample data and expected output. Make sure post it is in a table format, or share excel file, you can share excel using one drive/google drive.
Thank you for your quick reply. Here is a link with some sample data. The exam types are in Dutch, but you'll get the point.
Benjamin_Eureka Thanks but no idea how you get to those numbers? Could you explain the logic?
ah, I'm so sorry. I filled the output table with dummy numbers. The idea is that I can see, of the people who completed 'Exam B', if they also finished 'Exam A' (dummy names).
For instance:
There are 30 people who completed 'Exam B'. 20 of them also completed 'Exam A'. I want to check if those 20 received higher grades than the other 10.
Does this makes sense? I'm sorry for the lack of clarity.
Benjamin_Eureka I wish you had made excel file much easy to digest, we are talking Exam a and b, and in excel sheet you have all various text (i cannot relate) and the numbers in excel don't match with anything. would you mind putting the file again and explain, help me to get the help.