Excluded rows not reflected in count measure

[ssarma]

Hi All,

I have a summary (aggregated) table visual which displays the count for each product and I have enabled drillthrough where it expands to a table with individual rows corresponding to the count value. When I exclude certain rows from the drill through table (via Exclude option for individual rows), the counts in page 1 remain unchanged. Is there a way for the count values to accurately reflect the rows excluded in the drillthrough table?

Looking for advice on this. Thanks!

[ssarma]

@amitchandak thanks for your response. Is there a way to create a measure to display the count of rows in the visual table (ignoring excluded rows)?

[amitchandak]

@ssarma , I doubt action on the drill through page can be moved to page from where you are drilling(Base page)

You can use a sync slicer if you are excluding the values in slicer.

You can choose what to pass and not pass in drill through page not the vice versa