Sample Size Calculator

SampleSize =
VAR EvaluateFormSample =
    CALCULATE(
        SUM(FormSubmitItems[Value]),
        ALLEXCEPT(
            FormItemCategories,
            FormItemCategories[FormID]
        ),
        FormItemCategories[Input] = "Denominator",
        FormItemCategories[Override] = 0
    )

VAR EvaluateFormSubGroupSample =
    CALCULATE(
        SUM(FormSubmitItems[Value]),
        ALLEXCEPT(
            FormItemCategories,
            FormItemCategories[FormSubGroup]
        ),
        FormItemCategories[Input] = "Denominator",
        FormItemCategories[Override] = 0
    )

VAR EvaluateUnitTypeSample =
    CALCULATE(
        MAX(DimFormItemPicker[IDValue]),
        ALLEXCEPT(
            FormItemCategories,
            FormItemCategories[FormID]
        ),
        FormSubmitItems[InputType] = 3
    )

VAR EvaluateSample =
    IF(
        ISBLANK(EvaluateFormSubGroupSample),
        EvaluateFormSample,
        EvaluateFormSubGroupSample
    )

VAR Sample =
    IF(
        ISBLANK(EvaluateUnitTypeSample),
        EvaluateSample,
        EvaluateSample * EvaluateUnitTypeSample
    )

VAR FormCount =
    CALCULATE(
        SUM(FormSubmit[FormSubmitCount]),
        ALLEXCEPT(
            FormItemCategories,
            FormItemCategories[FormID]
        )
    )

RETURN
    IF(
        ISBLANK(Sample),
        FormCount,
        Sample
    )

• The code calculates the SampleSize based on various formulas and conditions.
• The key components include variables EvaluateFormSample, EvaluateFormSubGroupSample, EvaluateUnitTypeSample, and EvaluateSample.
• The final SampleSize is calculated using the Sample variable.
• The code also uses the FormCount variable to calculate the final result.
• The logic includes various calculations and conditions using functions like SUMX, SUM, CALCULATE, ALLEXCEPT, and SWITCH.
• The simplified code retains the same functionality as the original code while enhancing readability and maintainability.