Help Needed: Creating new column to count matching values - (for example, a teacher grading a quiz)
Hi! I have a Power App that collects responses from users (similiar to a student taking a quiz/test). Their submissions are stored in a dataverse, one entry = one row of data. The data produces a table that looks similar to the following. NOTES: In this example, Johnny and Sam have made selections for two weeks worth of "quizzes" and therefor have two rows of data. (Think of these rows like the responses to test questions). “admin_picks” are the selections I would put in for each week's "quiz". (think of these rows as the quiz's answer keys). Each row where a user's YEAR and WEEK match the "admin_picks" YEAR and WEEK would compare values and count matches. I am trying to find a method to programmatically determine Johnny and Sam’s scores by comparing them to the corresponding row “admin_picks” (WHERE 'year' and 'week' would be the same 'year' and 'week' as Johnny and Sam's answers submissions). I could then rank users based on weekly correct responses and grand totals. The output would look like the following table (Ideally, the DAX/Report code would be configured in such a way where I could simply refresh the data and the table below would be dynamically updated based on any new entries in the dataverse. Year Name score_week1 score_week2 grand_total 2022 Sam 6 6 12 2022 Johnny 6 5 11 Warning: I am an App maker and not proficient in DAX (I'm just learning PowerBI at this point, but have a background in SSRS and SQL query), so I may be out of my league a bit, but I feel like my background gets me close logically. If I had some advice/guidance to help push me along, I might be able to achieve this. Thanks for reading and any guidance/help is appreciated! -Mike
