Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SQRT error

Hello all, 

 

I am new to DAX and in need of some urgnt assistence. 

 

I am calculating the margin of error for survey results, currently attempting to do this in steps but I cannot seem to get the SQRT function to work. 

 

The formula I am trying to create in DAX is this: 

1.96*sqrt( ( p*(1-p)/n ) * ( (N-n)/(N-1) ) )

 

p= 0.896

I have created measures for N and n

 

My data looks like this and I have split the calculation into steps so I can monitor progress:

 

I cannot get the final step to work

MOE = SQRT(FullDataset[MOE a])

 

Can someone help. 

 

I do know that the I have the result of infinity for 3 records for MOE a where n = 0. But the SQRT of infinity is infinity I didnt think it would matter. 

 

Course CodeNn

MOE P 

( ( p*(1-p)/n )

FPC

( (N-n)/(N-1) ) )

MOE a

(MOE P)*(FPC)

( ( p*(1-p)/n ) * ( (N-n)/(N-1) ) )

MH123141519410.00010.77350.00008
AC35836104780.00020.21670.00004
MH113116714000.00020.76110.00018
MF152515554000.00020.74320.00017
AC151123133880.00020.83260.0002
AC150117403790.00020.78260.00019

 

Any help as urgently as possible would be amazing. 

 

Thanks so much, 

K

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You just need to add IF Function or IFERROR Function.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@Anonymous,

 

You just need to add IF Function or IFERROR Function.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks so much for responding. Iferror worked like a charm. 

Anonymous
Not applicable

Dear all, 

 

I need some help. 

 

I am trying to calculate the margin of error for a set of surveys. 

 

My formula is as follows:

1.96*sqrt( ( p*(1-p)/n ) * ( (N-n)/(N-1) ) )

 

I cannot get the SQRT function to work in dax so I have split my work up to a series of steps to aid analysis. My data now looks like this. my measures are in bold and I have included the calculation for each one. 

 

I now cannot get the final step of the equation to work. 

 

MOE = SQRT(FullDataset[MOE a]) but this does not work. I get an error. Can I get a square root of a measure? Or could it be due to a few infinity results in MOE a? There is also a NaN result. Woudl this make a difference?

 

It seemed like this was going to be so straightforward but I am very new to this and I just cannot figure this out. 

 

Course CodeNn

MOE P 

( ( p*(1-p)/n )

FPC

( (N-n)/(N-1) ) )

MOE a

( ( p*(1-p)/n ) * ( (N-n)/(N-1) ) )

MH123141519410.00010.77350.00008
AC35836104780.00020.21670.00004
MH113116714000.00020.76110.00018
MF152515554000.00020.74320.00017
AC151123133880.00020.83260.0002
AC150117403790.00020.78260.00019

 

Any help would be appreciated

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.