Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I am trying to create filtered views in a table, but can't figure out how to hide rows with measure having 0 or null value. I've tried disabling "Include 0 values" from data handling, and setting the output of this expression to display NUM values, but still not working. Expression below is calculating if date in Log for a record is within last day days.
=IF((today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp)))<90,NUM(today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp))),NUM(0))
Hi, how about changing NUM(0) to NULL() for the else parameter?
If the row doesn't hide, it means that you have another measure with a non-zero value on that row.