Measure for Average from below and above Average, Average.

[Pillic]

Hello comunity,

I was able to summarize the data and calculate the right average based on the summarization.

The measure I created looks like this 

Above/BelowAverage = 

VAR x_AVERAGE =  SUMMARIZE (
      Balken,Balken[STF-Art], 
             Balken[STF-Gehalt],
             Balken[Werk/ Standort], 
      "xx", 
      AVERAGE(Balken[maßg ffcflk, L1]) )

VAR x = AVERAGEX ( x_AVERAGE, [xx] )

Return 
x

This shows me the right values in a table visualisation.

Now I need an additional measure to calculate the average from all values above average and the average from all values below average. (not a conditional formating) 

It would be great if someone can point me to the right direction to achieve this.

Thanks in advance

[AlexisOlson · Accepted solution]

I think you can tweak what you have just a bit.

AboveAvgerage =
VAR x_AVERAGE =
    SUMMARIZE (
        ALLSELECTED ( Balken ),
        Balken[STF-Art],
        Balken[STF-Gehalt],
        Balken[Werk/ Standort],
        "xx", AVERAGE ( Balken[maßg ffcflk, L1] )
    )
VAR x_TotalAVG = AVERAGEX ( x_AVERAGE, [xx] )
VAR x = AVERAGEX ( FILTER ( x_AVERAGE, [xx] >= x_TotalAVG ), [xx] )
RETURN
    x

[Pillic]

Great!!! that shows me the results, perfect!
Thanks Alexis and everyone else who had a look at this.

[ValtteriN]

Hi,

You could use your measure to filter your data and calculate average from there. E.g.

data:

Example:

Average of below average = CALCULATE(AVERAGE('Below/over average'[Value]),FILTER('Below/over average','Below/over average'[Value]<CALCULATE([Average example],ALL('Below/over average'))))

End result:

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Pillic]

Hello ValtteriN,

thanks for the hint, but it doesnt gives me the expected result or i have a typo:

Average of above average = 

  CALCULATE(AVERAGE(Balken[maßg ffcflk, L1]),FILTER(Balken,Balken[maßg ffcflk, L1] < CALCULATE(InterpolationDF28[Above/BelowAverage],ALL(Balken))))

The average measure shows me the average from the filtered values in the blue frame. Compared to this is green above and red are the below values. I need a way to calculate the average from green and also from red.