topic Re: Connecting multiple data points in DAX Commands and Tips

Connecting multiple data points

matout — Tue, 22 Dec 2020 15:20:06 GMT

Hello,

I am trying to analyze a survey answers which has 800+ rows based on multiple data points, from within the some questions answers. the survey has 119 questions, each question with 5 options.

For example

I want to classifiy each rows as

- Organized, semi organized, not organized.

Organized classification is

Question number	Option
Question 1	Option 2
Question 5	Option 3
Question 6	Option 4
Question 13	Option 5
Question 44	Option 1

And semi organized as for example

Question number	Option
Question 1	Option 3
Question 5	Option 1
Question 6	Option 5
Question 13	Option 2
Question 44	Option 4

is this obtainable? and how

thank you

Re: Connecting multiple data points

amitchandak — Tue, 22 Dec 2020 15:31:33 GMT

matout ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Re: Connecting multiple data points

matout — Tue, 22 Dec 2020 16:15:23 GMT

Hello, thank you for the answer

I have a survey. with 119 question, each question is a column.

each answer for the survey is a row in the table.

for example

Company ID Bank Account? Accounting Practice Accountant? External Auditor Online Banking?

1 yes Accounting system Yes No No No

2 No Accounting records Yes No No No

3 Yes Accounting system Yes yes Yes No

I want to classify each company (row) as Organized, Semi Organized and Not organized.

based on thier answers to the questions.

For example, if a company has a bank accout, Accounting practice, Accountant, Registered trade name and Tax number

this company will be labeled as organized.

I have other criteria for semi organized and other for not organized

Is this obtainable and how?

Thank you

Re: Connecting multiple data points

amitchandak — Wed, 23 Dec 2020 03:46:31 GMT

matout , a new column like

new column =
Var _1 = if([Bank Account]= "Yes" ,1,0) + if(not(isblank([Accounting Practice])),1,0)+ if([Accountant]= "Yes" ,1,0) + if([External Auditor]= "Yes" ,1,0) + if([Online Banking]= "Yes" ,1,0)
return
Switch( True() ,
_1 = 5, "Organized",
_1 >0 , "Semi Organized",
"Not organized"
)

Change as per need

Re: Connecting multiple data points

matout — Sun, 27 Dec 2020 15:19:15 GMT

Hello, thank you for the answer.

this solution is helpful, however, there are 3 different values in the "Accounting practice" column.
How can I diffrentiate them, this is not just true or false.