Freeze table even if filter used

[TITO22]

Hi everyone,

I have a table of sales : 

I created two table visualisation : sales by month / sales sum by product and month 

Now, i want to freeze my left table even if i use the month filter. That is possible? 
I tried to create a measure : Measure = CALCULATE(SUM(SALES[SALES]),ALL(SALES[MONTH])) 
But it doesn't work 

[v-zhangti · Accepted solution]

Hi, @TITO22 

You can try the following methods.

New table = VALUES('Table'[MONTH])

Measure = CALCULATE(SUM('Table'[SALES]),FILTER(ALL('Table'),[MONTH]=SELECTEDVALUE('New table'[MONTH])))

This visual will not interact with the source table.

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Dangar332]

Hi, @TITO22 
@TITO22 

use visual level filter for second table only(sales sum by product and month )

see below image

[TITO22]

The expected result is to have multiple tables (4,5...) in the report. Si i can't use a filter for each table. I have to use the page level filter

[Dangar332]

Hi, @TITO22 

you cannot control the interaction with filter pane. page level filter will filter all the visuals on that page.

my suggestion is create a new calculated table for that column which you want to show in visuals is not affected by page level filter .

not connect that table with data model

refer below link for same problem Link 1  ,Link 2 

[Nithinr]

you can use edit interation feature in power bi. @TITO22 

Edit interactions in Power BI - SQL Skull

[TITO22]

To use edit interaction i must insert a slicer in the report. In my case i have to use the filter panel