Distinct Count filter column in Filter Panel

[srahman2015]

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??

[v-angzheng-msft]

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:

https://community.powerbi.com/t5/Desktop/How-do-I-filter-a-column-in-a-calculated-table-based-on-ano...

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.

[Fowmy]

@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;

[srahman2015]

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 · Accepted solution]

@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])