Sum and filter a table based on a condition in another table

Hi

Please follow below steps to achieve expected results.

Step 1 :- 

Unpivot section columns from QualityData Table using Power Query. so, that you will get all sections in one column.

Step 2:-

Then create relationship between both table using Section Column. one to Many Relationship

Step3 :-

You will get correct results for Actual Score without any context modification

Step 4:

For getting Possible Score, Use below formula.

Possible Score =

        CALCULATE(

                    SUM(MarkReference[Marks]),

                    CROSSFILTER(MarkReference[Section],QualityTable[Section],Both)

        )

 

 

 

Please accept solution, if it resolve your issue.

 

Thanks & Regards

Pravin Angane