Forum Discussion
Distinct Count filter column in Filter Panel
Hi,
I have a visual in my report which gives me a distinct count of ID against Sales Stages
In the filter pane, I have the Sales Stage filter but the count on the right shows the count of Sales Stage in the data for all rows
Is there a way of producing a filter (possibly with a calculated column) to do a distinct count on the ID for the Sales stage, so the numbers on the right in the filter match the numbers in the visual??
srahman2015
You cannot change the aggregation on the filter pane but you can change it on the visual. You can use a measure like
Measure1 - Count(Table[Column])
4 Replies
- Fowmy
Super User
srahman2015
Some filters are applied to the table visual that is why you see a lower number perhaps. You click on the filter icon on the visual header and check what filter they are;Hi Fowmy
Thanks for your response!
Is there a way of making the numbers the same in the filter pane on the right hand side of the report to match the numbers in the grid?
The only difference between the grid and the filter pane is that the grid is doing a distinct count on the ID column whereas the filter pane isn't. I'm thinking possibly a calculated column on the SalesStage with a filter on the ID to be a distinct count but not too sure how this would work.
- Fowmy
srahman2015
You cannot change the aggregation on the filter pane but you can change it on the visual. You can use a measure like
Measure1 - Count(Table[Column])
- v-angzheng-msft
Community Support
Hi, srahman2015
Unfortunately, calculated tables are created during the data refresh, they are not re-calculated every time a filter changes. So the counts in the filters pane will only ever show the number for the whole data set.
For reference:
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
