Power Platform Community Forum Thread Details

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.

Example table.PNG