Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Zyg_D
Continued Contributor
Continued Contributor

Comparing to average

This is my simplified data:

image.png

Actually I only have the first 3 columns (no last blue column). I tried to create it, but I failed. I think I need it, because my final goal is to create a pie chart with only 2 pieces (above/below average) of only area1. Smth like this:

image.png

How should I go about it?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Would it work with calculated column?

above/below = IF(AVERAGE('Table'[grade]) > 'Table'[grade], "below average", "above average")

 

View solution in original post

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi @Zyg_D ,

 

If you wanna create a pie chart,you need to create a calculated column as below:

 

above/below = 
var _ave=AVERAGEX(FILTER('Table','Table'[area ]="Area 1"),'Table'[grade]) Return
IF('Table'[grade]>_ave,"above average","below average")

 

Finally,you will see:

Annotation 2020-05-07 152729.png

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
amitchandak
Super User
Super User

@Zyg_D ,

Try

Above or Below = IF(AVERAGEX(all('Table'),'Table'[grade]) > 'Table'[grade], "Below average", "Above average")
Above or Below = IF(calculate(AVERAGE('Table'[grade]),allexcept('Table','Table'[grade])) > 'Table'[grade], "Below average", "Above average")
Anonymous
Not applicable

Would it work with calculated column?

above/below = IF(AVERAGE('Table'[grade]) > 'Table'[grade], "below average", "above average")

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.