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!
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.