Breaking down the normal distribution by attributes

Hi Anonymous ,

First of all, your model relationship may be a bit problematic, it should be like this:

Secondly, the results returned by your two percentage measures may have problems, please refer to the following formula:

Percent of respondents = 
VAR x = 
CALCULATE(
    DISTINCTCOUNT('Sample'[External Data Reference]),
    ALLEXCEPT(
        'Sample',
        'Sample'[Sector]
    )
)
VAR y = 
CALCULATE(
    DISTINCTCOUNT('Sample'[External Data Reference]),
    ALL('Sample')
)
RETURN
DIVIDE(
    x,
    y,
    BLANK()
)

Percent of total Population = 
VAR x = 
CALCULATE(
    DISTINCTCOUNT(Population[ID]),
    ALLEXCEPT(
        'Population',
        'Population'[Sector]
    )
)
VAR y = 
CALCULATE(
    DISTINCTCOUNT(Population[ID]),
    ALLSELECTED('Sample'[Sector])
)
RETURN
 DIVIDE(
    x,
    y,
    BLANK()
) 

Left_Tailed_Hypothesis = 
NORM.DIST(
    [Percent of respondents], 
    [Percent of total Population],
    1,
    TRUE()
)