Forum Discussion

zebra's avatar
zebra
Helper II
2 years ago
Solved

Calculating Normal Distribution based on selected values (slicer/filters)

Hi All, I am having hard time in calculating dynamic normal distribution based on selected slicer/filter data. Here is the use case, lets say I have people data with age, city and country and I want...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    zebra 

    Please use following measure:

    Norm.Dist = 
VAR __Mean = CALCULATE( AVERAGE(Sheet1[Age]) , ALLSELECTED( Sheet1 ))
VAR __StdDev = CALCULATE( STDEV.S(Sheet1[Age]) , ALLSELECTED( Sheet1 ))
VAR __Result =  NORM.DIST( AVERAGE( Sheet1[Age]) ,__Mean  ,__StdDev,FALSE())
RETURN
   __Result







Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi zebra ,

 

I understand what you're saying, but there doesn't seem to be a way to resolve that issue for you. It does depend on the data. It's like if you arrange data with a small gap, it will tend to present as a straight line.

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • zebra's avatar
    zebra
    Helper II
    2 years ago

    well... it does not relly depend on it. this is the generic problem. here the actual problem is how power bi calculate the calculated column and measure. since i have created the calculated column for normal distribution so it is taking the average and standard deviation of whole data whears we need these values for only barcelona data. and the problem is that we can not use measures in calculated columns. this is the actual problem.