Forum Discussion
Using a Filter with SummarizeColumns
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
Anonymous ,
You can simply take sum of Revenue in visual. Not able to get advantage of summarizing column?
OK, but the example I mentioned illustrates a specific issue I have with a much larger piece of work. It isn't possible to share the project and so I have condensed the issue I am having in to the specific question asked. Because of it's simplicity I am sure that it's a non-issue but sadly not in the work I am doing.
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