Why am I getting Empty and 0 values in table ?

[Anonymous]

Hi,

I am wondering why am I getting both 0 and empty values at the same time ?

How can i fix my measures such that the table will display "0" consistently?

Volume this week =

var _max = TODAY()

var _min = _max - 7

var _volweek = CALCULATE(SUM(Message[Number Of Messages]),FILTER('Date','Date'[Date] <= _max && 'Date'[Date] >= _min))

Return

_volweek

Volume 1 week ago =

var _max = TODAY()

var _min = _max - 14

var _vol = CALCULATE(SUM(Message[Number Of Messages]),FILTER('Date','Date'[Date] <= _max && 'Date'[Date] >= _min))

var _volweek = _vol - CALCULATE(SUM(Message[Number Of Messages]),FILTER('Date','Date'[Date] <= _max && 'Date'[Date] >= _max - 7))

Return

_volweek

[Anonymous · Accepted solution]

I have been able to fix the problem:

I updated the return statement into:

Return

if(_volweek = BLANK(), 0,

if(_volweek > 0, _volweek)

[Ashish_Mathur]

Hi,

In the Number of messages column of the Messages table, there are entries which are 0's and also blanks.  It's just a guess.

[Anonymous]

@Ashish_Mathur I checked the data set and the Number of Messages in the Messages Table. The values are neither blank nor 0. The number of messages column is only populated when messages are sent during a specific date.