filtering to only happen on the SUM

[georgehtan]

Hi All, does anyone know if its possible to filter an aggregation expression in a group by? if so how would i go about doing that? something like group by column1, column2, column3,filter column 4(starts with " ") sum column5, count column6 Thank you

[ray_ux · Accepted solution]

@georgehtan Sounds like you need a calculation function () for the measure?
here a example,  summarize( Table, Column1, Column2, Column3, "Sum", calculate( sum(), left(column4) <> " ")) // it should be something like that.