Forum Discussion
Freeze table even if filter used
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
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.
6 Replies
v-zhangtiCommunity Support
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.
To use edit interaction i must insert a slicer in the report. In my case i have to use the filter panel
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
Resident Rockstar
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
