Research Survey 1 to 10 scale question - show percentage selecting 9 to 10

[mrloopy]

I'm very new to Power BI, trying to show the percentage of people selecting 9 or 10 (1-10 scale question) on a bar chart with multi products.  I can show average but can't figure out how to show % 9 and 10.

Products - G,J,R (Q1)

Example data file...

Any help would be appreciated.

[harshnathani]

Hi @mrloopy ,

Use the below measures:

Total Respondents = DISTINCTCOUNT('Table'[Resp])

Selected 9 or 10 = CALCULATE(COUNT('Table'[Resp]), FILTER('Table', 'Table'[Value] = 9 || 'Table'[Value] = 10))

%9or10 = DIVIDE([Selected 9 or 10],[Total Respondents])

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[mrloopy]

Works great, thanks.  1st time I've used measures, I have to do some more training on those.

One more quick question, how do you change the %9to10 to show the % sign?  Mine show decimal.

[harshnathani]

Hi @mrloopy ,,

Regards,

Harsh Nathani.

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[mrloopy]

Wow, that was simple, thanks!!!!