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 ,

 

This is a problem with the data itself, see below:

 

It suggests that this part of the data is not well suited for a normal distribution

 

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

I think I am unable to explain the problem well. please see the screenshot below

 

in this screenshot, we have two graphs. i numbered them as 1 or 2. both represents barcelona data.  here I want to have graph 1 similar to graph 2 however this is not despite of the fact that both represent barcelona data. the only difference is that graph 1 is made from that data that consists of all cities data along with barcelona however filtered from top.  please see sheet 1 data. the graph 2 consist of only barcelona data. please see sheet 2 data. 

 

I hope i clear the problem, here i only want both graphs should be similar. it does not matter that this data is suitable for normal distribtion or not.  please let me know if there is any other ambiguity.