cancel
Showing results for
Did you mean:
Helper I

## Measure for Average from below and above Average, Average.

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.

1 ACCEPTED SOLUTION
Super User

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

4 REPLIES 4
Super User

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

Helper I

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

Super User

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!

Proud to be a Super User!

Helper I

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.

Announcements

#### The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

#### Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

#### Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!