Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Average of Text?

I have this table:


So these are survey responses. 17 questions total. The majority of the feedback has been "Positive". How can I write a measure that will give a single overall value of "Positive" for this client? Rather than using 17 mixed responses for a single survey, whatever Feedback Group appears the most should be the overall experience a user had. Trying to count how many positive vs negative vs netural experiences we have. 

Super User
Super User

Hi @Anonymous 

If you just want the max:

1. Place Table1[Co] in the rows of a table visual

2. Place this measure in the visual

Measure =
VAR FBTable_ =
        DISTINCT ( Table1[Feedback Group] ),
        "CountF", CALCULATE ( COUNT ( Table1[Feedback Group] ) )
        DISTINCT ( Table1[Feedback Group] ),
        TOPN ( 1, FBTable_, [CountF], DESC )

Please always show your sample data in text-tabular format in addition to (or instead of) the screen captures. A screen cap doesn't allow people to readily copy the data and run a quick test and thus decreases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here. Or, ideally, share the pbix (beware of confidential data).


Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors