Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

CALCULATETABLE Function error

I am using the following expression to poulate a measure:-   TestMeasure = CALCULATETABLE( 'Table', 'Table'Field <> BLANK() )   Which is returniong the following error: -       The expression...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    CALCULATETABLE returns a table but then you are passing this whole table into a measure, which expects a scalar value. How about using MAX('table'[column])? 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

CALCULATETABLE returns a table but then you are passing this whole table into a measure, which expects a scalar value. How about using MAX('table'[column])? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous thanks for the reply.

     

    I had assumed as much (I'm quite new to PowerBI but I have a strong T-SQL background). 

     

    I am simply trying to select the maximum Date (ColA) from Table1 where ColB is not null. Im I going about this the wrong way? 

     

    I used you solution in my first itteration but it does not allow for the NULL filter.

     

    Thanks