Forum Discussion
How to make filter counts match distinct values
Can you please share a sample file if possible to check this ?
I went ahead and created a sample. Here's a link to the PBIX. You'll notice that there are a total of 10 visits, but that some of those visits have multiple report categories. These reflect correctly on the pie chart and table - the pie chart is correct because I use a measure to DISTINCTCOUNT the VisitID. However, if you look at the Filters, you can see the problem. The Report Categories are correct, because if you select them, you get that number of items in the pie chart. However, you'll see that the Market Segment filters are incorrect - for example, it says that there are 55 Digital Marketing visits, but if you filter by that value, you get 7 results (which is correct).
- v-yingjl5 years ago
Community Support
Hi jimforjim ,
Based on your description, you want the page filter count should be the same as pie visual count right?
If so, I'm afraid you could not acheive this in power bi currently because the count of each field in the level filters is based on the whole data table by default and we could not change it. In addition, even if we use measures, they could only be put in visual filters, page filters does not allow measures.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.