SUM IF multiple measure conditions

[Anonymous]

Hi!

I am looking to display sales IF $ was spent on demos or samples. 

I've created a measure for both - 'demos' and 'samples' to be calculated and filtered based on GL acct. 

Although the calcuation does not work below - this is along the lines of what I am looking to create:

CALCULATE([Total Sales]), FILTER([demos] <> 0 || [samples] <> 0 )  

Any help would be greatly appreciated! 

Thank you! 

Christina

[Greg_Deckler · Accepted solution]

@Anonymous Assuming that sales is something like SUM('Table'[Sales]) try:

Measure =
  SUMX(FILTER('Table', [demos] <> 0 || [samples] <> 0 ), SUM('Table'[Sales]) )

[Anonymous]

Thank you, @Greg_Deckler !!

It worked using your example:

Sales = SUMX(FILTER(_Measures,[Demos] <> 0 || [Samples] <> 0 ), [Total Sales])

There are some customers that still show up as a zero under samples - do you know the easiest way to filter these out?

My DAX expression is:

Samples = CALCULATE([Total GL], 'GLEntry'[GL Account No] = "xxxxxx" )

Thanks again,

Christina

[Greg_Deckler]

@Anonymous Just use the Filters pane and filter out where Sample = 0

[Anonymous]

@Greg_Deckler  Oh right! of course...

I added OR Is Blank in the filter as well.

Thank YOU!!!