Count the number of table visual rows after user excludes a row

[LLGreen]

I have a page in a Power BI report with a table visual (7 columns) that is filtered by three page-level filters and two report-level filters (in the Filters pane). Above that is a card visual that shows the number of rows in the table visual (it counts the number of rows in the data table that fit two criteria). Some users have been editing the table visual by right-clicking on rows they don't want and choosing "Exclude", which removes the row from the table visual (setting up a visual-level filter that excludes all the combined column values from the that row); however, the card visual still shows the count based on the data table. For example, the table visual starts with five rows, and the card visual shows 5. The user then "Exclude"s one row, leaving only four showing in the table visual, but the card visual still says 5.

Is there a way to count only the number of rows that are visible in the table visual, and not the count from the filtered data table? I've tried various combinations of CALCULATE, COUNTROWS, and ALLSELECTED, but to no avail.

[v-sgandrathi]

Hi @LLGreen,

Thank you @danextian, @ryan_mayu @lbendlin  @Praful_Potphode  for your responses to the query and the contribution.

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

[Praful_Potphode]

Hi @LLGreen 

to propogate the filter to the card visual, try using  ISFILTERED/VALUES/TREATAS/SELECTEDVALUE DAX combination to create your card value.what this will do is when you exlcude something ,these dax functions will check the current filter state and then return the count.

PLease give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful

[LLGreen]

Can you give me an example of how you would set this up?

[lbendlin]

[danextian]

Hi @LLGreen 

You can count the number of rows a table visual returns by creating a virtual table of the columns the visual has. Below is an example

However, unless the card is cross-highlighted and/or there is a slicer selection that can affect both visuals, the value in the card won't update as the the filter as applied to the visual only - excluding/including a row creates a visual not page level filter.

[ryan_mayu]

@LLGreen 

when you do the exclude action in the table visual, that means you will add a table visual filter. So the visual level filter will only affect that visual. If you want to affect other visuals, it's better to add a slicer and ask users to select in that slicer. 

[lbendlin]

You will need to experiment with the FILTERS() function  to have a chance at this.

FILTERS function (DAX) - DAX | Microsoft Learn