Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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.
@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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
64 | |
62 | |
57 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |