Card not showing correct count when using table visual filters

[BeAStar]

I have a table with multiple filters (20 or more) that the user can select as needed, Also have slicers that have pre-determined filtering, I want to be able to show on a card the total count of records in the table after applying multiple Visual filters. Currently the card only shows count of records filtered by the slicers but won't change when selecting filters in the visual. In the example total products should show 87 but card count is not showing filtered count

[TheoC · Accepted solution]

@BeAStar okay, I figured out what is going on! Completely a rookie error on my part.  The color filtering you are doing in the Filter pane is at the Visual level, not at the page level.  

Below is using the Countrows with a Slicer:

Below is the Countrows however filtering Color on the table visual:

Ultimately, when you have the slicers in there, and you are filtering, it won't be an issue.  If you want to use the Filter pane options, then just add colour to the page filter level like below:

Hope this helps!

Theo 🙂

[TheoC]

Hi @BeAStar 

Can you please share the measure you're using for your card visual?

Thanks,

Theo

[BeAStar]

countrows()

[TheoC]

@BeAStar 

I assume it is "Measure = COUNTROWS ( 'TableName' )"?

Is the colour of your products in your products table?  If not, have you established relationships between the various tables?  

[BeAStar]

Yes that's the measure and Yes it is on the same table

[TheoC]

Are you able to share some data or the PBIX.  It's likely that there is something in your model that is indirectly / unintentionally creating this.

[BeAStar]

unfortunately I can't, but here is a simple example

Name              Gender Child                Color

Colleen Rowley	F	Marshall Watt	Red
Colleen Rowley	F	Jagoda Watt	White
Luc Watt	M	Marshall Watt	Blue
Luc Watt	M	Jagoda Watt	Green
Marshall Watt	M	Jake Watt	Red
Marshall Watt	M	Corban Watt	Green
Sanna Barton	F	Jake Watt	Red
Sanna Barton	F	Corban Watt	White
Rikki Brooks	M	Riley-Jay Brooks	Blue
Rikki Brooks	M	Dixie Brooks	Green
Jagoda Watt	F	Riley-Jay Brooks	Red
Jagoda Watt	F	Dixie Brooks	Green
Riley-Jay Brooks	M	Evie-Rose Brooks	Red
Aila Allison	F	Evie-Rose Brooks	White
Dixie Brooks	F	Eliot Rosales	Blue
Andy Rosales	M	Eliot Rosales	Green
Jake Watt	M	Lyle Watt	Red
Jake Watt	M	Romana Watt	Green
Meredith Salinas	F	Lyle Watt	Red
Meredith Salinas	F	Romana Watt	White
Corban Watt	M	Jacqueline Watt	Blue
Jaya Lovell	F	Jacqueline Watt	Green
Lyle Watt	M		Red
Romana Watt	F		Green
Jacqueline Watt	F		Red
Evie-Rose Brooks	F		White
Eliot Rosales	M		Blue

[TheoC]

@BeAStar the 27 count, that suggests there are more records being within the context of the measure. If you want the distinct colour count, you will need to use a different measure that calculates the count of color occurrences by category. I believe you may want to use the count of names in the KPI card and you should get 9 instead of 27.

Let me know if it works k.

Cheers,

Theo

[BeAStar]

unfortunately, I have over 20 different fields that can be filtered at any one time so this would not be a feasible solution, but thank you for the option.

[TheoC · Accepted solution]

@BeAStar okay, I figured out what is going on! Completely a rookie error on my part.  The color filtering you are doing in the Filter pane is at the Visual level, not at the page level.  

Below is using the Countrows with a Slicer:

Below is the Countrows however filtering Color on the table visual:

Ultimately, when you have the slicers in there, and you are filtering, it won't be an issue.  If you want to use the Filter pane options, then just add colour to the page filter level like below:

Hope this helps!

Theo 🙂

[BeAStar]

Thanks @TheoC I have way too many visual filters for user to select and adding them to the page would take the whole page, was hoping to get the count without having to use slicers. Thanks again for the options!!

[TheoC · Accepted solution]

@BeAStar no problem.  As long as you understand that by adding the filter at the Visual level, you are restricting the filter to that Visual.  If you want to have other visuals on the page filtered based on a filter selection, then just move filter from the Visual to the Page level.  This gives you what I gather you are after (e.g. no slicers and the KPI card to give the number of row in the table).

All the best with it!

Theo