filtering survey questions

[giorgiokatr]

question	customer	anwser
1	a	ok
1	b	good
1	c	ok
2	a	rew
2	b	yellow
2	c	black

i have this survey with two pie visuals each for each question

visual has tyhe answer and the count of customers.

when i click on good for example in the visual the other visual is blank because dataset is filtered in question id 1. is there a way to show the answer of the customers than answered good what did the answer in other questions in the second visual?

[Anonymous · Accepted solution]

Hi @giorgiokatr ,

Since the slicer is from the same table, the visual will be affected the slicer.

There are two ways might solve the problem.

One way is to create a slicer table which has no relationship with fact table and use SELECTEDVALUE() function to get the count of value by slicer.

Another way is create a measure use ALL() function to get the count of value, for example:

CALCULATE(COUNT(value),FILTER(ALL(table),column=SELECTEDVALUE(column))).

Best Regards.

Jay

[giorgiokatr]

the problem is when i click on answer ok from first question the second visual should show me the result for the two customers  that answered ok (customer a and c). it should show in my example one for rew and one for black (the answers of those two customers)

[giorgiokatr]

@amitchandakno it does not work the second visual is not showing results per filter.

[amitchandak]

@giorgiokatr , use a measure with removefilters(Table[anwser])

calculate(coutrows(Table) , removefilters(Table[answer]))

check example at https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak