how to display # of records in a table visual with a filter?

[ppgandhi11]

Hi,

I referred to this page: https://community.powerbi.com/t5/Desktop/Display-number-of-records-in-table-visual-vs-number-of-reco...

My source table (combination of tables with joins) has 10 records, but when i select a specific filter value, the # of records shown is 5. Total # of records always displays 10 because I am using countrow() function in the card below the visual. How can I get # of records returned with filters in effect?

I have in fact multiple filters on the page. So ideally the # of records displayed should be based on all the filters current selected value. But that should work if it works for one.

Thanks!

[v-yulgu-msft]

Hi @ppgandhi11,

In my test, the total number of records calculated with CountRows() is affected by slicer filter. Please post sample data and all necessary measure formulas to make your scenario more clear.

Regards,

Yuliana Gu