Calculated column

[ariaz]

Hi everyone. Need help in analyzing a survey questionnaire in Power BI. I am trying to equally distribute "Netural" responses to "Agree" and "Disagree" and cannot figure it out. Can someone please suggest a solution to this. I have columns Employee ID, Country, Question and Answer in my survey. Your early response and help will never go unappreciated. Thanks

[ariaz · Accepted solution]

Hi @Kishore_KVN ,
I recreated the logic to get the desired result, using your provided DAX:

AgreeColumn = IF(Datasource[Answer]="Agree",1,IF(Datasource[Answer]="Neutral",0.5,BLANK()))

Disagreecolumn = IF(Datasource[Answer]="Disagree",1,if(Datasource[Answer]="Neutral",0.5,BLANK()))

Above two columns worked out for me.

Appreciate your help and I am closing this as "Solved" 😊

[ariaz]

Hi Kishore. Let me try the solution that you provided and will mark it as "Accept as solution" if it works. Appreciate your help

[Kishore_KVN]

Hello @ariaz , create two columns 

1. Agree Column and its DAX will be 

Agree Column = If(Response = "Agree"||Response = "Neutral",1, Blank())

2. Disagree Column and its DAX is also the same by changing to disagree. It looks as below:

Disagree Column = If(Response = "Disagree"||Response = "Neutral",1, Blank())

Then in your visualization, you can use the sum to get the total values of Agree and Disagree.

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!