Get percentage from survey data with text values

[Anonymous]

Hi, I have survey result with text values - one question and answer per column. Now I would like to calculate the percentage of each text value in a column in Power BI. Please let me know how to get about. Thanks in advance!

[parry2k]

@Anonymous we need to write a custom measure to achieve, what represents subscription?

[Anonymous]

@PattemManohar what do you mean with subscription?

[parry2k]

@Anonymous you need to add following measure and use % measure in table visual.

Total of Subquestion = 
CALCULATE( 
SUM( Table[Verde], 
ALLEXCEPT( Table, Table[attribute], Table[attribut (grupper)]
)

% = DIVIDE( SUM( Table[Verde] ), [Total of subquestion] )

[Anonymous]

@PattemManohar now it says that SUM has too many arguments...

[parry2k]

@Anonymous you are missing bracker ) after [Verde], it should be sum(Sheet1[varde])

[Anonymous]

@PattemManohar great - now the first code works. Where do I put in the second code? Thanks in advance 🙂

[parry2k]

@Anonymous similar to first one, it will be another measure.

[Anonymous]

@PattemManohar this is how it looks now.

[parry2k]

@Anonymous you have to add new measure you added "%" to "Verde"

[Anonymous]

@PattemManohar what do mean with adding it to Värde? This how it looks now

[parry2k]

@Anonymous you need to add % measure to verde as shown below.

[Anonymous]

@PattemManohar thanks but now it looks like this

[parry2k]

@Anonymous Can you share pbix file I will make the changes and send it back to you.

[Anonymous]

@PattemManohar great but how do I share it with you?

[parry2k]

@Anonymous thru google drive or onedrive

[Anonymous]

@PattemManohar  what emailaddress?

[Anonymous]

@PattemManohar , I inserted the code but it did not like it - see below

[parry2k]

@Anonymous you have to change the name of table in the dax to your table name, which is sheet. Replace all table with sheet

I assumed you know the basics of DAX, sorry I should have been more careful in my expression.

[Anonymous]

@PattemManohar where will I put in the code? Please show me and thanks in advance.

[parry2k]

@Anonymous add new measure and add those two measures one by one, these are two different measures. click three dot on table and select new measure from menu.