2 filter on summarize table

Question

Hi ,I want to create a table by summerize function, but I need to insert two filter conditions(I need to filter the data by year and by an " X " field of the data set), is it possible?

alexchen · Answer

Hi,&nbsp;I advise you to use “SummarizeColumns” function to do it.&nbsp;Now I assume you have a table called “prod” like below.&nbsp;&nbsp;You can create a table use the following code.The products that are created before 2010 and amount value that are less that 2000 are filtered.&nbsp;Table = SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prod[product],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;filter(prod, year(prod[createdDate]) &gt; 2010 &amp;&amp; prod[amount] &gt;= 2000),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"amt", sum(prod[amount])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )&nbsp;&nbsp;Best RegardsAlex&nbsp;&nbsp;

fabiocesarei · Answer

Hi Alex, thank for reply. Filter is supported in summarize, I have used this example SUMMARIZE(FILTER('Time';'Time'[year]=2015);'Time'[quarter]; "CostQtr";SUM('Fact_costs'[.......
and it worked.
perhaps power bi converts the function.
I have to use 2 fields of different tables in filter function, do I have to create a previous table with a filter option and the second field as column and use it as filter in the final one?

Thanks

Fabio

Forum Discussion

2 filter on summarize table

2 Replies

Related content

Merge Summarize Table

Parameter table dimensions - summarize

Parameter in summarize

Filtered table

filtering summarized table