Forum Discussion
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...
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])?
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])?
The problem was that I was trying to stuff a table into a scalar variable.
I fyou need the solution to the main issue please check https://community.powerbi.com/t5/Desktop/SELECT-MAX-Date-FROM-Source-WHERE-Reference-Column-IS-NOT-NULL/m-p/316533/highlight/false#M140644
Thanks