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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Survey Data - Display average results below a value

Hello Everyone, 

 

I'm trying to make a simple calculation but just can't figure out the DAX formula to do it. 

 

I have a survey with 6 categories of questions. Each category has 3 to 6 questions, answered with Strongly Disagree, Disagree, Agree, Strongly Agree. I've unpivoted the questions and answers and made a conditional column to grade each response with -10, -5, 5 and 10. This is how it looks: 

 

PBIDesktop_7fojFyZukj.png

 

I'm making an average of each answer per category for example in Training there are 3 questions: (10 + 10 - 5) / 3 = an average of 5

 

The way I display that is in a table, and I can simply ask the value to display as average or use a DAX formula like this: 

 

Average Score = Average(questions[Score])
 
What I'm trying to do is to see how many people have an average below 5 in each category. How I tried so far is with this formula:
 
_No. of employees < 5 = CALCULATE(COUNTAX('Append1', [ID]),'questions'[Score]<= 5 )
 
But it calculates each answer individually, so it doesn't really give me the number of people, but the number of answers below or equal to 5. 
 
Later on, I want to see how many people in each group/account have a score below 5. The way I see it so far is with a table like this, but I don't want to count each red tab, in each group, but to have a direct answer. (The first column is filled with people ID) 
 

 

2 REPLIES 2
Anonymous
Not applicable

Any help please, i will give more information if needed. 

Anonymous
Not applicable

PBIDesktop_ah1wvJsbNr.png

 

I don't know why it didn't take my last pic.

 

Thank you very much for all your help! You guys are amazing!

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.