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 )
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 )
You are a genius, thank you so much. This is ace
Have a fabulous weekend, you've made me very happy
Kind regards
Karen
