CALCULATETABLE

[paris]

Hi All,

I would like to select Apple, Orange and Banana's sales in 2018. How can I add Orange and Banana to the following formular?

2018 = CALCULATETABLE(Sales,Sales[Year]=2018, Sales[Product]="Apple")

All the best,

Paris

[Mariusz · Accepted solution]

Hi @paris

You can use the expresion below.

CALCULATETABLE(
    Sales,
    Sales[Year] = 2018, 
    Sales[Product] IN {"Apple", "Orange", "Banana"}
) 

Hope this helps
Mariusz

[Mariusz · Accepted solution]

Hi @paris

You can use the expresion below.

CALCULATETABLE(
    Sales,
    Sales[Year] = 2018, 
    Sales[Product] IN {"Apple", "Orange", "Banana"}
) 

Hope this helps
Mariusz

[paris · Accepted solution]

Thank you very much! It saved my time a lot.