I am fairly new to powerBi and a first time poster, so sorry for any incompleteness in my posting. I am analyzing survey results. I have one column that returns a list of all the departments they have worked with to at our company. I then added a slicer to find if that broke out the deparments and searched in the department column to update the results:
Then I filter on the Chart to show Is Filtered = 'True'
But when the chart updates it does not bring in the correct count for anything, it updates the column values perfectly, but it is still retaining the count prior to the slicer.
The photos below are the original without clicking on a deparment. For this example I click on coolsculpting as the department, (they should only have one reason, "I am healthy and do not need a portal" as reference in image 3). It is returning the reason correctly, but it is still has the number as 4 when it should be 1. What Am I missing.
Could you please share some sample data and provide more details about how to reproduce your scenario? In above post, you said "It is returning the reason correctly, but it is still has the number as 4 when it should be 1", how did you calculate the count value?
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.