Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Great!!! that shows me the results, perfect!
Thanks Alexis and everyone else who had a look at this.
Hi,
You could use your measure to filter your data and calculate average from there. E.g.
data:
Example:
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/
Proud to be a Super User!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |