I have a table in Excel that acts as a Q&A form. There are multiple answers in a dropdown list and each answer has a score (each question is also weighted). This is used to calculate a weighted score by multiplying each score by its weight and adding all of that together. Depending on what the answer is, the score would change.
I thought this was easily done in Power BI (with a slicer for the questions and answers and then a data card showing the calculated score) but I ran into issues creating independent slicers on the same page.
Here is an example table that I want to create in Power Apps (with the formula visible for the 'score with weight' cell). Note that the answers are dropdowns.

Report
All responses (
Answers (