cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TzachiGolan Frequent Visitor
Frequent Visitor

VISUALIZING & COMBINING MULTIPLE ANSWERS SURVEY

Hello to all DAX experts

need your help ASAP, 

 

I have a DIM table of survey questions and answers ( containing all possible combinations of it )

and it looks like this : 

QUE_ANS_ID ( PK )

QUE_ID
QUE_TITLE
ANSWER_ID
ANSWER_VALUE
and a fact table of customers answers that built like this :

QUE_ANS_ID

CUST_ID
QUE_SYS_ID
ANSWER_ID
QUE_TITLE
ANSWER_VALUE

How can I create a filter/ measure that showes a combination of selected answers in the answer value coulmn instead of only one  ?

In other words I want to  " translate "  this SQL query to DAX :

 

select count (cust_id )
from a_fact_cust_answ
where que_id in ( 1,2)
AND answer_value in ('Male' , 'Yes')

Today , for example   ,if  I want to see all Male customers that own a car ,   I get a results of all male and ALL the customers that own a car 

 

 

I think it can be done by a complex filter but i dont realy know how to format it ( q&a in hirrachy and the count of the ID)

 

Any help would be much appreciated

Thanks !

3 REPLIES 3
Nathaniel_C Super Contributor
Super Contributor

Re: VISUALIZING & COMBINING MULTIPLE ANSWERS SURVEY

TzachiGolan Frequent Visitor
Frequent Visitor

Re: VISUALIZING & COMBINING MULTIPLE ANSWERS SURVEY

@Nathaniel_C  I'll be specific ...  I have a survey 

 

CUST_IDQUE_TITLEANSWER_VALUE
2318066GenderMale
2318066Do you live in New-York City ?Yes
2318066Select the best description of your daily activity level.Fully active
2318546GenderMale
2318546Do you live in New-York City ?Yes
2318546Select the best description of your daily activity level.Some  Active
2330326GenderFemale
2330326Do you live in New-York City ?Yes
2330326Select the best description of your daily activity level.Some  Active
2337367GenderMale
2337367Do you live in New-York City ?Preffer not to answer
2337367Select the best description of your daily activity level.Some  Active
2389586GenderFemale
2389586Do you live in New-York City ?Yes
2389586Select the best description of your daily activity level.Some  Active
2399889GenderMale
2399889Do you live in New-York City ?Yes
2399889Select the best description of your daily activity level.Fully active
2421779GenderFemale
2421779Do you live in New-York City ?Yes
2421779Select the best description of your daily activity level.Some  Active

 

How can I create a filter / Slicer  that showes a combination of possible results ? 

for example , Customers that are male AND live in NY AND fully active

 

 A regular slicer on the answer value  showes my the results for Male OR  live in NY  ( could be female.. )  OR  fully active

Do you have any ideas ?...

 

Thanks !

TzachiGolan Frequent Visitor
Frequent Visitor

Re: VISUALIZING & COMBINING MULTIPLE ANSWERS SURVEY

@Nathaniel_C  I'll be specific ...  I have a survey 

 

CUST_IDQUE_TITLEANSWER_VALUE
2318066GenderMale
2318066Do you live in New-York City ?Yes
2318066Select the best description of your daily activity level.Fully active
2318546GenderMale
2318546Do you live in New-York City ?Yes
2318546Select the best description of your daily activity level.Some  Active
2330326GenderFemale
2330326Do you live in New-York City ?Yes
2330326Select the best description of your daily activity level.Some  Active
2337367GenderMale
2337367Do you live in New-York City ?Preffer not to answer
2337367Select the best description of your daily activity level.Some  Active
2389586GenderFemale
2389586Do you live in New-York City ?Yes
2389586Select the best description of your daily activity level.Some  Active
2399889GenderMale
2399889Do you live in New-York City ?Yes
2399889Select the best description of your daily activity level.Fully active
2421779GenderFemale
2421779Do you live in New-York City ?Yes
2421779Select the best description of your daily activity level.Some  Active

 

How can I create a filter / Slicer  that showes a combination of possible results ? 

for example , Customers that are male AND live in NY AND fully active

 

A regular slicer on the answer value  showes my the results for Male OR  live in NY  ( could be female.. )  OR  fully active

Do you have any ideas ?...

 

Thanks !

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,401)