Table Visual NOT Affected by Slicer, but Measure Should be Filtered by Slicer

Question

Hi, everyone!&nbsp;I have three tables: aggregated, dim_content, dim_content_sender.&nbsp;Dim_content and dim_content_sender have HarvesterID Column.Aggregated table consist of TotalClicks, HarvesterID (which connects to dim_content[HarvesterID]) and PageHarvesterID (which connects to dim_content_sender[HarvesterID]).&nbsp;The logic is aggregated table contains number of clicks to the page (aggreagted[HarvesterID]) from page (aggregated[PageHarvesterID])&nbsp;And my need is next. Report page is filtered by&nbsp;dim_content[HarvesterID], but on one visual I need to show clicks to other pages from selected&nbsp;dim_content[HarvesterID].&nbsp;&nbsp;Result table:dim_content[HarvesterID]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TotalClicks (where&nbsp;aggregated[PageHarvesterID] =&nbsp;dim_content[HarvesterID] selected in slicer)&nbsp;So, the problem is I need this table be not filtered by&nbsp;dim_content[HarvesterID], but the measure should be filtered. Is this possible somehow?&nbsp;Many thanks in advance!&nbsp; &nbsp;&nbsp;

amitchandak · Accepted Answer

Anonymous , If you stop the interaction, none of the values will filter, even measure.&nbsp; (Means stop interactions will not work for you) 
&nbsp;
You can create other measure in using all /removefilters
calculate([measure1], removefilters(dim_content[HarvesterID]))
&nbsp;
Or you may have to use an independent table
refer video: https://www.youtube.com/watch?v=lOEW-YUrAbE
&nbsp;

Forum Discussion

Table Visual NOT Affected by Slicer, but Measure Should be Filtered by Slicer

2 Replies

Related content

Measure not affected by filter

Slicer panels affecting bookmarks

Determine which filters/slicers affects a visualisation

Slicer affected by other slicer

CALCULATE with REMOVEFILTERS still affected by slicer