Sum sales without order date

[pedroccamaraDBI]

Hello all
I need a measure to sum all my sales, that order date are blank.
Can you help?
Thanks a lot

[tamerj1 · Accepted solution]

Hi @pedroccamaraDBI 
Many options. The easiest is to create two calculated columns using (IF)
- Column1 returns zeros for blanks and one for other rows.
- Column2 return 1 for blanks and zero for other rows
Sales amount without blanks would be SMX ( Sales, Sales[Sales] * Sales[Column1] ) 
Sales amount with blanks would be SMX ( Sales, Sales[Sales] * Sales[Column2] ) 

Another option would be to use
SUMX ( FILTER ( Sales, NOT ISBLANK ( Sales[Sales] ) ), Sales[Sales] ) for sales without blanks
SUMX ( FILTER ( Sales, NOT ISBLANK ( Sales[Sales] ) ), Sales[Sales] ) for sales with blanks

[pedroccamaraDBI]

Awesome. Thank you so much @tamerj1 

[tamerj1]

SUMX(

FILTER(

Table,

ISBLANK(Table[Order Date])

),

Table[you column name]
)

[amitchandak]

@pedroccamaraDBI , Try a measure like

calculate( sum(Table[sales]), filter(Table, isblank(Table[order date]) ) )

[pedroccamaraDBI]

Hello @amitchandak 
I don't think it's working. Don't you think it would be better with an iteractive measure?
The calculation will be line by line but only if order date is blank. Can you still help me?

[amitchandak]

@pedroccamaraDBI ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[pedroccamaraDBI]

Here it goes @amitchandak 

I still don't know if the values are blank, or null or just weird blanks, you know? 1 thing i know: that column is date formated.
Thank you all

[tamerj1]

@pedroccamaraDBI 
Are you getting this from a visual? Is the order date is in the same Sales table?

[pedroccamaraDBI]

Yes @tamerj1 Order Sales same table as sales, and Date from Dates