Skip to content

DAX function TABLEOF not recognised as returning a table reference when passed as argument to ALL* functions. #1569

@OwenAuger

Description

@OwenAuger

Description

When TABLEOF ( ... ) is passed as an argument to any of the ALL* functions, Tabular Editor appears not to recognise that TABLEOF returns a table reference, and erroneously reports an error of the form
"The ALL* function expects a column or table reference for argument 1."

Tabular Editor 3 Version

3.26.1

Screenshots

Image

Steps to Reproduce

  1. Open Tabular Editor 3
  2. File > New > Model
  3. Untick Use workspace database
  4. Click OK
  5. Model > Add Calculated Table
  6. Name table Dummy
  7. Enter expression SELECTCOLUMNS ( { 1, 2, 3 }, "Dummy", [Value] )
  8. Right-click Dummy > Create Measure
  9. Name measure DummyMeasure
  10. Enter expression
    CALCULATE ( COUNTROWS ( Dummy ), ALL ( TABLEOF ( Dummy[Dummy] ) ) )
  11. Observe that TABLEOF ( Dummy[Dummy] ) is red-underlined with error message "The ALL function expects a column or table reference for argument 1."

Expected behavior

When TABLEOF ( ... ) is passed as an argument to any of the ALL* functions, Tabular Editor should recognise TABLEOF as returning a table reference, and not show a Semantic error.

Crash Report

No response

Windows Version

11

Metadata

Metadata

Assignees

No one assigned

    Labels

    issue: bugConfirmed as a bug in TE3

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions