topic Re: Filter on visuals based on selected value but different logic in DAX Commands and Tips

Filter on visuals based on selected value but different logic

szoradam — Fri, 28 Feb 2025 13:13:29 GMT

Hello,

I have a data set of customer satisfaction surveys where data is organized according to the below picture. Answer headers contains info about 1 fill of the survey, answer details holding the per question data.

We are showing every question of the survey in a separate visual, using the answer__details / Value_or_OptionHU field.

I would like to achive a filtering where user clicks on some value of a visual (i.e. one slice of a pie chart) then all other visuals/questions on the page are being filtered to show answers where the users gave the same answer for the selected corresponding question.

Example:
Question 1: How would you rate us?
Options: 1,2,3,4,5
If i click on the pie chart's slice that shows the 5 ratings, the other visuals of other questions should show the answers (of other questions) where the answer of the same user for the 1st question was 5.

Here are my tables:

My approach was to find all AnswerIDs where the same answer for the same question was given and filter the visuals of the page to those, but cannot make it work....

FilteredAnswerIDs =

VAR SelectedQuestion = SELECTEDVALUE(answer__details[QuestionID])

VAR SelectedValue = SELECTEDVALUE(answer__details[Value_Or_OptionHU])

RETURN

CALCULATE(

DISTINCT(answer__details[AnswerID]),

answer__details[QuestionID] = SelectedQuestion,

answer__details[Value_Or_OptionHU] = SelectedValue

)

I would appreaciate any suggestion 🙂

Many thanks!

Adam

Re: Filter on visuals based on selected value but different logic

lbendlin — Sat, 01 Mar 2025 00:04:39 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Filter on visuals based on selected value but different logic

AilleryO — Mon, 03 Mar 2025 11:01:28 GMT

Hi,

Could it be related with your filters, it shloud be AND, isnt't it ?, so :

answer__details[QuestionID] = SelectedQuestion &&

answer__details[Value_Or_OptionHU] = SelectedValue

With a comma you get the equivalent of OR.

Does it solve your problem ?

Re: Filter on visuals based on selected value but different logic

szoradam — Tue, 04 Mar 2025 11:34:02 GMT

Sorry if my question was not clear enough.
Probably this code of my measure will be more speachful for you:

CountOfResults = VAR mySelectedQuestionID = SELECTEDVALUE(answer__details[QuestionID]) VAR mySelectedValue = SELECTEDVALUE(answer__details[Value_Or_OptionHU]) VAR SelectedAnswerIDs = IF ( NOT(ISBLANK(mySelectedQuestionID)) && NOT(ISBLANK(mySelectedValue)), FILTER( ALL(answer__details), answer__details[QuestionID] = mySelectedQuestionID && answer__details[Value_Or_OptionHU] = mySelectedValue ), ALL(answer__details) ) RETURN COUNTROWS( FILTER( ALL('answer__details'), NOT(ISBLANK('answer__details'[value_or_optionhu])) && 'answer__details'[AnswerID] IN SELECTCOLUMNS(SelectedAnswerIDs, "AnswerID", answer__details[AnswerID]) ) )

What i would like to achieve is based on the selected values in the context, i get a list of answerIDs (so far it is working), and then I would like to count the rows of my 'answer__details' table where the answerID is in the list of the IDs I previously calculated. Chatgpt is not able to help we are going in circles as suggesting to use selectcolumn(), values(), but cannot manage to get the IDs out of my variable in a proper way to be able to use with the "IN" condition.