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
countrows()
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?
Yes that's the measure and Yes it is on the same table
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