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!
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!