Ok so I have various questions and i'd lik eto create a new measure which will give me a count of the number of answers
eg, I like football
10 = agree completeley
8 = somewahat agree
and so on
How would I do this please ? Is it something along the lines of measure = countx(sheet1,Sheet1[Answer]="agree completely") I can't seem to get this to work.
Alternatively how could i go about making numerous pie charts to show the answers of 7 or 8 questions without uploading them as sepreate sheets?
Go to Solution.
Quite Similar to your formula
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!