ashleymf1983
New Member
- Joined
- Jul 20, 2021
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
Hello All,
Brand new to DAX here.
Background: I am using dummy survey data to attempt to learn DAX. There's 4 survey questions, scored on a Likert scale ("Strongly Agree", etc). I have already recoded the Likert scale answers into codes (a scale of 1 to 4). Here's the data for one of the questions. I am trying to insert a measure to calculate the % that answered with each possible response, for each question. My start with DAX has been rocky even though I am great with Excel functions! Thanks to anyone who might be able to help!
Dummy Data:
Desired outcome:
I tried this DAX below but you'll see what's wrong with that..
divide(countrows(Table), countx(all(Table), Table[reponse]))
Incorrect result I received:
Each row should have a total of 100%, not 25%.
Thanks for any help you can offer!!
Brand new to DAX here.
Background: I am using dummy survey data to attempt to learn DAX. There's 4 survey questions, scored on a Likert scale ("Strongly Agree", etc). I have already recoded the Likert scale answers into codes (a scale of 1 to 4). Here's the data for one of the questions. I am trying to insert a measure to calculate the % that answered with each possible response, for each question. My start with DAX has been rocky even though I am great with Excel functions! Thanks to anyone who might be able to help!
Dummy Data:
Desired outcome:
I tried this DAX below but you'll see what's wrong with that..
divide(countrows(Table), countx(all(Table), Table[reponse]))
Incorrect result I received:
Each row should have a total of 100%, not 25%.
Thanks for any help you can offer!!
