Slicer doesn't work for one of two selected values

[Anonymous]

Hi guys,

I'm facing a rather unusual slicer problem with a report. I have a table with 2 fields "movieID", "language". I have only 2 languages which are EN & FR. A movies can either be in EN or FR language.

Now I created a visual to count movies by ID, and a slicer with "language" as the field. However, when I select "FR", the slicer works and I can see the number of movies in French, but when I select "EN", it doesnt work, as the KPI remains the same. I shows total number of movies instead of number of movies in English only.

I checked the excel raw data and filtered by language and it works, so it's not a data source problem. Does anyone have an idea what the problem could be? Here's the measure for my count.

No. of movies = DISTINCTCOUNT (Table(movieID))

[v-lid-msft]

Hi  @Anonymous ,

Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

Best regards,

[v-lid-msft]

Hi @Anonymous ,

Based on your description, we created a sample and test your measure, it works,

Does the ”language“ field you used in slicer comes from the fact table? Have you tried to apply visual filter in the chart to test if it works? We can also create a calculated table “Dim = DISTINCT(‘Table’[language])” and create a relationship with fact table , then use it as the slicer.

BTW, pbix as attached.

Best regards,