Forum Discussion
Using a Filter with SummarizeColumns
New day, new question. I have an issue with a project I am working on. In this simplified example, I have a table, t_Revenue with fields Project, Year and Revenue. Project Year Reven...
Anonymous , Let us take it like this. If you take the filter and create a table, a new table it will not be dynamic. But it is created part of measure it will be dynamic.
We use summarize columns, summarize to have sql subqueries. sometimes we force a row context
example
measure
=sumx(summarize(sales,sales[customer_id], "_Cnt",count(sales[customer_id])),if([_cnt]>1,1,0))Or take max till project level and then sum
Or sum project having revenue >10000
True.
In Anonymous 's case, it is used as a persistent table. Therefore the filter is not gonna work. It would not be possible to filter the t_Summary table dynamically based on the Year slicer selection. That is the conclusion. Correct?
No, I would create a measure structured like this:
VAR __Table = SUMMARIZECOLUMNS(...)
RETURN
<some calculation over __Table>
Then it is dynamic and can take the year filter into account.
VAR __Table = SUMMARIZECOLUMNS(...)
RETURN
<some calculation over __Table>
Then it is dynamic and can take the year filter into account.