Joining multiple formulas into one

nmck86

Hi, you can use variables inside the measure.

My TestValidation 2% =
VAR Quality_10_Score_Count =
    CALCULATE ( COUNT ( Sheet1[Quality] ); Sheet1[Quality] = 10 )
VAR Quality_Score_10_and_Recommended_Score_9_or_10 =
    CALCULATE (
        COUNT ( Sheet1[Quality] );
        Sheet1[Quality] = 10;
        Sheet1[Recommended] = 10
            || Sheet1[Recommended] = 9
    )
VAR Quality_Score_10_and_Recommended_Score_9_10_V2 =
    CALCULATE (
        COUNT ( Sheet1[Quality] );
        Sheet1[Quality] = 10;
        Sheet1[Recommended] <= 6
    )
VAR Test_Validation_2_Recommended_Score = Quality_Score_10_and_Recommended_Score_9_or_10
    - Quality_Score_10_and_Recommended_Score_9_10_V2
RETURN
    Test_Validation_2_Recommended_Score / Quality_10_Score_Count

Regards

Victor

Lima - Peru