topic Calculate average in a calculated column in DAX Commands and Tips

Calculate average in a calculated column

Navyaragamm — Fri, 05 Jul 2024 06:33:49 GMT

Hi ,

I am stuck on some calculations, please help me out

The issue is the result> (Average+2*STD.DEV) and result< (Average-2*STD.DEV) if both are true then the result is yes or no

Here the result is the value of the row

And average is average of the value within one component and standard deviation is deviation of the value within one component

Here to calculate the outlier what is best a calculated column or a measure

Also can anyone help with the dax on how to compare the values

Above are the calculations and nab free are components

I should be able to get by outlier based on the above calculation

Also, I want to have a slicer of the same to filter

Can anyone know how to do all the calculations

Help is appreciated

Re: Calculate average in a calculated column

foodd — Wed, 03 Jul 2024 15:43:01 GMT

Hello Navyaragamm , perhaps you mistakenly added your Excel post to the Fabric Community where the Community Members focus upon all things Microsoft Fabric related. For your convienience we are supplying the link to the Excel (microsoft.com) Community.

Re: Calculate average in a calculated column

Navyaragamm — Wed, 03 Jul 2024 16:04:22 GMT

Hi foodd

Excel sheet was an example of the calculations,i want to replicate it in the power bi desktop

I tried calculating it the power bi taking upper and lower dax measures and in a calculated column I have done the comparison but all I get is No

Upper =

Var avg = average(data[value])

Var std = stddev.p(data[value])

Return avg+2* std

Same for lower

Then in the calculater column I have used

Outlier = if(data[value])> upper && data[Value]< lower , " Yes" , "No")

If I take this the measure instead of column the visuals are loading And I also want a slicer of the outlier field