Forum Discussion

Shivani_06's avatar
Shivani_06
New Member
2 years ago

Cross filter from same table

Problem with cross-filtering the same table in report. ‎ Hello, I am working with questionnaires, so I have a table user_question table that looks like this:     And User table    ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Shivani_06 

 

Based on your description, I am afraid that your situation can not be fully realized, the following methods are for your reference:

 

1. create a table as the slicer

Question_name = VALUES(user_question[question_name])

 

2. create several measures as follow

User_count = CALCULATE(DISTINCTCOUNT(user_question[user_id]), user_question[question_name] in VALUES(Question_name[question_name]))

 

Related_count = 
VAR a =
    CALCULATETABLE (
        DISTINCT ( user_question[user_id] ),
        ALLSELECTED ( user_question ),
        user_question[question_name] IN VALUES ( Question_name[question_name] )
    )
VAR b =
    CALCULATE (
        DISTINCTCOUNT ( user_question[user_id] ),
        ALLSELECTED ( user_question ),
        user_question[answer_name] IN VALUES ( user_question[answer_name] ),
        user_question[user_id] IN a,
        user_question[question_name] IN VALUES ( user_question[question_name] )
    )
RETURN
    b

 

 

 

Best Regards,
Yulia Xu

 

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

Shivani_06's avatar
Shivani_06
New Member
2 years ago

Hi Anonymous , 

 

Thank you so much for your feedback. 

 

I am looking for cross filtering solution which I have mentioned above but in this case if I uncheck slicer my 1st visual will give me all users who have given answer to all questions but I wanted to see actual count of user for particular question at first and also I want to see actual count of users in 2nd visual as well that is not possible without uncheck slicer. 

 

And I want to see related count only if I select any answer from 1st visual so that it crossfilter and give me the count of user who have answered to other question as well in 2nd visual. 

 

And If I have not selected any answer on visual then it must show user count for particular question for each visuals with there respective question name flter.

 

I can't have any slicer on page but can have visual level question filter. Also I may have to compare two or more questions visuals on same page.

 

Regards,

Shivani_06