Table in drill through contains more rows than on visual

[nikkirai99]

Hi all,

I have a visual that shows 13 rows but when I drill through this visual, the total in the drill through page is 14. The visual has the following filter:

Latefilter = Calculate(count('Table'[PortfolioID]), filter('Table', CONTAINSSTRING('Table'[Holding], "Late" )))

In the drill through, the total contains not only "late" but "early" as well. Somehow the filter is not working. How can I fix this? Thank you!

[some_bih · Accepted solution]

Hi @nikkirai99 according to your calculation logic is to calculate from table 'Table'[PortfolioID] 

but condition is another table and column 'Table'[Holding] having value "Late".

Check your relationship, and your tables to validate either measure result or your visual check. 

Details are important, maybe empty string or something cause difference.

[nikkirai99]

Hi @some_bih Thank you for pinpointing the problem. I changed the filter to the same table and column and it worked!