FILTER won't work on GENERATE OR SUMMARIZE Table

[clem312]

Hi,

I have created one table with the function CROSSJOIN. Hopefull filter works with it.

I have created another one with SUMMARIZE or GENERATE. Filters don't work... 😭 How come ?

I specify that of course I am talking about dimension outside the new table but included in the initial table.

[amitchandak · Accepted solution]

@clem312 , how you have used filters?

Are you hoping slicer values to work, that will not.

but 

Filter(Summarize(<Code>) , [Col1] =1)

or

Summarize(Filter(Table, [Col1] =1), [Col1], [Col2] )

should work

Should work