Forum Discussion
Super Userhow to create table Summarizecolumns keep filter context
Hi there,
I have a table with following 3 columns and there is a slicer on date and I'm trying to create a calculated table with keeping current filter context from date slicer:
column in my table : Category, date, amount
This is the command I'm trying for calculated table:
Table3 Is Zero = SUMMARIZECOLUMNS(Table3[Category],Filter(Table3,Table3[Amount]=0), "IsData",CountRows(Table3))
What I'm getting in summary table for all the rows from table3 not what is selected on date slicer, how I can keep the filter context from table3.
If you use that function inside a measure the answer is YES. But if want to use to create a new table (Like Summarize or CalculateTable) is not possible.
The calculated table is preprocessed before use slicer visual to filter data. So we are not able to use the checked slicer value in the calculated table. (v-qiuyu-MSFT)
7 Replies
- parry2k
Any suggestion, or alternate solution for this.
