Forum Discussion

marjoriefialek's avatar
marjoriefialek
Icon for Helper I rankHelper I
5 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

marjoriefialek , you can try like this

measure  =

var _1 = calculate([measure], allexcept(Table[Date])) +0

return

calculate([measure],_1 <>0 )