Power Bi Summarise Table with no blanks

PHOTO EMBED

Fri Nov 05 2021 02:39:14 GMT+0000 (UTC)

Saved by @Darkleech #vba

Action Totals (Dynamic) = CALCULATETABLE(SUMMARIZE('All Audit Actions','All Audit Actions'[Topic]),'All Audit Actions'[Topic]<>BLANK())
content_copyCOPY

Using the calculate table allows for filters

https://community.powerbi.com/t5/Desktop/SUMMARIZECOLUMNS-Excluding-rows-with-blank-values-in-one-of-the/m-p/501234