Iteration with multiple column conditions

Hi Khalefa 
Please try

% Score =
IF (
    0
        IN CALCULATETABLE (
            VALUES ( 'Table'[Score] ),
            'Table'[Attribute] IN { "Compliance", "Image" }
        ),
    0,
    SUMX ( 'Table', 'Table'[Score] * 'Table'[Weight] / 100 ) / 100
)

Khalefa 
Please refer to attached sample file with the final solution.

Weighted Score = 
SUMX (
    VALUES ( 'Fact'[Review ID] ),
    IF (
        0
            IN CALCULATETABLE (
                VALUES ( 'Fact'[Score] ),
                Dim_Attribute[Attribute] IN { "Compliance", "Image" }
            ),
        0,
        SUMX (
            CALCULATETABLE ( 'Fact' ),
            'Fact'[Score] * RELATED ( Dim_Attribute[Weight] ) / 100
        )
    )
)

Total Weight = 
SUMX (
    VALUES ( 'Fact'[Review ID] ),
    SUMX (
        CALCULATETABLE ( 'Fact' ),
        RELATED ( Dim_Attribute[Weight] ) 
    )
)

% Score = 
DIVIDE (
    [Weighted Score],
    [Total Weight]
)

hi Khalefa 

How is the Sample table related to your Dimension Table?

Hi Khalefa 
Please refer to attached sample file with the solution (2 options)

% Score = 
AVERAGEX ( 
    VALUES ( Scores[Review ID] ),
    IF (
        0
            IN CALCULATETABLE (
                VALUES ( Scores[Score] ),
                Scores[Attribute] IN { "Compliance", "Image" }
            ),
        0,
        SUMX ( CALCULATETABLE ( Scores ), Scores[Score] * RELATED ( Weights[Weight] ) / 100 ) / 100
    )
)

% Score2 = 
AVERAGEX ( 
    VALUES ( Scores[Review ID] ),
    VAR T1 = CALCULATETABLE ( Scores )
    RETURN
    IF (
        ISEMPTY ( 
            FILTER (
                T1,
                Scores[Attribute] IN { "Compliance", "Image" }
                    && Scores[Score] = 0
            )
        ),
        SUMX ( T1, Scores[Score] * RELATED ( Weights[Weight] ) / 100 ) / 100,
        0
    )
)

Just a simple question, How can I add the PBiX file

i just need to upload the model sample to be clear enough

I have added here the model for more visibility:-
1- weight column is in a dim table
2- I need to use all the dim to filter the fact 
3- the dax should consider that if attributes of Compliance or image are zero so all attributes of that review ID are zero other wise sum score * weight at the review level granularity 

https://drive.google.com/drive/folders/1Zkd_6sS582BE8NfHxITV1Gku4njHsk4A?usp=sharing

tamerj1 
the results should be as follow

total weighted score (145 ) / total weight (400) 

Sumx output should be divided by total weight not just 100