Forum Discussion

mWilkinson's avatar
mWilkinson
Frequent Visitor
6 years ago
Solved

Measures using Calculate on a table with multiple filters

So i'm having a few issues trying to work out marketing expenses by category.    I have a table called "6201 Marketing Expense" and this contains the company's marketing expenses as "Debit"    th...
Need Help
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    I think if you write it that way it effectively does a logical AND between the filter conditions (which will eliminate all the rows).

     

    You could probably simplify this down to the following:

    Online Ad Cost =
CALCULATE (
    SUM ( '6201 Marketing Expense'[Debit] ),
    '6201 Marketing Expense'[Supplier Account] IN { "Rightmove", "Zoopla", "ListGlobal" }
)

     

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

I think if you write it that way it effectively does a logical AND between the filter conditions (which will eliminate all the rows).

 

You could probably simplify this down to the following:

Online Ad Cost =
CALCULATE (
    SUM ( '6201 Marketing Expense'[Debit] ),
    '6201 Marketing Expense'[Supplier Account] IN { "Rightmove", "Zoopla", "ListGlobal" }
)