Forum Discussion
SWITCH
I'm trying to create a new column using the SWITCH function and I'm using the DAX formula below. The issue I have is if there is a blank for Gainline Prev the DAX formula is reading it as a 0 and add...
jamieham ,
You can create a measure like
calculate([Meausre], filter(Table, not(isblank(Table[Gainline Prev]))))
Or you can use visual level or page filter Table[Gainline Prev] <> Blank ()