Forum Discussion
Card not showing correct count when using table visual filters
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 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
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.
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 |
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
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.
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 🙂