Forum Discussion
Exclude Columns with ALL zero values
I have a matrix visual with conditional coloring and icons. In order to accomplish this I had to convert NULLS into zeros. However, I would like to exclude the columns that have all ZEROS. In Powe...
marjoriefialek , you can try like this
measure =
var _1 = calculate([measure], allexcept(Table[Date])) +0
return
calculate([measure],_1 <>0 )