Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I´d like to build a DAX where I can use the summarizecolumns DAX but filter out or omit the "null" values on the column A. I´m not sure where to add the filters on within the DAX
Go to Solution.
@manuelfigueirat SUMMARIZECOLUMNS can include filters as well. Please check the following code.
Table = SUMMARIZECOLUMNS (
FILTER( 'Table1', 'Table1'[ColumnA] <> BLANK() )
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
View solution in original post
Hello @Fowmy ! It worked very well! Thanks a lot! 🙂 You are a super user definetley!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.