Search code examples
powerbidaxpowerbi-desktopmeasure

Simple table expression resulting from CALCULATETABLE function returning error

Error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

tbExcess Vel OA Lim := 

CALCULATETABLE(
    fWMSL_VibrationsAppended,
    FILTER(
        ALL(fWMSL_VibrationsAppended[Velocity Overall,in/sec]),
        fWMSL_VibrationsAppended[Velocity Overall,in/sec] > 1.25
    )
)

I'm not sure where I'm going wrong here.

I'm using CALCULATETABLE to filter the original table 'fWMSL_VibrationsAppended' to where column [Velocity Overall,in/sec] is a value greater than 1.25. I'm using FILTER instead of the simpler boolean expression because I'm still learning how DAX works and just trying to drive home the implicit mechanism.

Solution

  • Measures cannot return a table and must return a scalar value instead. If you want to return a table, you can create a calculated table instead.