How to return values where other column is not blank?

[k3rz0rg]

Hi all,

I have a measure in which it returns the sum of revenue where the sale count is not 0 and not blank and tried the following code but I don't think its working. Can somebody help me with that?

Measure = SUM([Revenue])
                  ,AND( [Sales Count] <> 0, ISBLANK([Sales Count]) <> FALSE )

Thanks!

[DOLEARY85 · Accepted solution]

Hi,

try something like this:

Measure = CALCULATE(sum('Table'[Revenue]),not(isblank('Table'[Sales Count])),'Table'[Sales Count]<>0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[mario_ruiz]

Can you see any error when creating this measure? Seems the parenthesis and the order of the arguments is not correct. You should use something like this:

Measure = 
IF (
    [Sales Count] <> 0 && NOT(ISBLANK([Sales Count])),
    SUM([Revenue])
)

[DOLEARY85 · Accepted solution]

Hi,

try something like this:

Measure = CALCULATE(sum('Table'[Revenue]),not(isblank('Table'[Sales Count])),'Table'[Sales Count]<>0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[k3rz0rg · Accepted solution]

Hi @DOLEARY85 , 
thanks for the code correction and NOT() was the keyword I was looking for hence I'm marking that as solution! 
Although even the corrected code was not working and was giving me the "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed." error. So I had to put all the condition inside the filter function (thanks to @amitchandak for the filter hint on one of his replies in the community).
FILTER(not(isblank('Table'[Sales Count])),'Table'[Sales Count]<>0))
Thanks again!