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

[Anonymous]

Hi, everyone!

I have three tables: aggregated, dim_content, dim_content_sender.

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]).

The logic is aggregated table contains number of clicks to the page (aggreagted[HarvesterID]) from page (aggregated[PageHarvesterID])

And my need is next. Report page is filtered by dim_content[HarvesterID], but on one visual I need to show clicks to other pages from selected dim_content[HarvesterID]. 

Result table:

dim_content[HarvesterID]         TotalClicks (where aggregated[PageHarvesterID] = dim_content[HarvesterID] selected in slicer)

So, the problem is I need this table be not filtered by dim_content[HarvesterID], but the measure should be filtered. Is this possible somehow?

Many thanks in advance!

[amitchandak · Accepted solution]

@Anonymous , If you stop the interaction, none of the values will filter, even measure.  (Means stop interactions will not work for you)

You can create other measure in using all /removefilters

calculate([measure1], removefilters(dim_content[HarvesterID]))

Or you may have to use an independent table

refer video: https://www.youtube.com/watch?v=lOEW-YUrAbE

[Anonymous]

Knew that, but was hoping that there can be another way. But still, thank you for the reply!)