Forum Discussion
Solved
Create Sample Size in DAX
Hi there Happy Friday everyone Can someone help me please? I'm trying to calculate a sample size value from a dataset. For example below My overall total count is 24074 I want a 95% con...
Sample Size Required =
VAR N = COUNTROWS( 'YourTable' )
VAR Z = 1.96
VAR p = 0.5
VAR E = 0.03
VAR n0 = ( Z * Z * p * (1 - p ) ) / ( E * E )
VAR nCorr = ( N * n0 ) / ( N + n0 - 1 )
RETURN
ROUNDUP( nCorr, 0 )
Here's the DAX for the sample size calculation:
Sample Size =
VAR Population = 24074
VAR Z = 1.96 // 95% confidence
VAR p = 0.5 // proportion
VAR e = 0.03 // margin of error
VAR Numerator = (Z * Z * p * (1 - p)) / (e * e)
VAR Denominator = 1 + ((Z * Z * p * (1 - p)) / (e * e * Population))
RETURN
DIVIDE(Numerator, Denominator)
VAR Population = 24074
VAR Z = 1.96 // 95% confidence
VAR p = 0.5 // proportion
VAR e = 0.03 // margin of error
VAR Numerator = (Z * Z * p * (1 - p)) / (e * e)
VAR Denominator = 1 + ((Z * Z * p * (1 - p)) / (e * e * Population))
RETURN
DIVIDE(Numerator, Denominator)
Replace 24074 with COUNTROWS(YourTable) to make it dynamic. This will give you ~1022.
💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn: https://www.linkedin.com/in/kedar-pande
Best regards,
Kedar
🌐 Connect on LinkedIn: https://www.linkedin.com/in/kedar-pande