Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculatetable

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous,

    According to your snapshot, it seems like you use CALCULATETABLE function in calculated column expression.

    AFAIK, the CALCULATETABLE function will return a table with multiple columns and it not suitable with calculated columns, I'd like to suggest you use this formula in calculated table expressions.

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous,

    According to your snapshot, it seems like you use CALCULATETABLE function in calculated column expression.

    AFAIK, the CALCULATETABLE function will return a table with multiple columns and it not suitable with calculated columns, I'd like to suggest you use this formula in calculated table expressions.

    Regards,

    Xiaoxin Sheng

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Anonymous 

    Are you expecting an expression like this:

     

    =CALCULATETABLE(Sales, Sales[Location] = "Bangalore")