Forum Discussion

paris's avatar
paris
Icon for Helper V rankHelper V
7 years ago
Solved

CALCULATETABLE

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[Produc...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi paris

    You can use the expresion below.

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

    Hope this helps
    Mariusz

  • paris's avatar
    paris
    7 years ago

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

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi paris

You can use the expresion below.

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

Hope this helps
Mariusz

  • paris's avatar
    paris
    Icon for Helper V rankHelper V
    7 years ago

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