Skip to main content

    Power BI

    Needs Votes

    Function 'CALCULATE' is not allowed as part of calculated column DAX expressions in DirectQuery models

    Vote (32) Share
    Tibo's profile image

    Tibo on 09 Aug 2018 22:46:12

    I'm connecting to a SQL server in DirectQuery mode.
    While I can add a calculated column I can't use the Calculate function to generate the content of that column.
    Error Returned is "Function 'CALCULATE' is not allowed as part of calculated column DAX expressions in DirectQuery models."

    Comments (1)
    Tibo's profile image Profile Picture

    Alan Jones on 20 Jul 2023 13:18:06

    RE: Function 'CALCULATE' is not allowed as part of calculated column DAX expressions in DirectQuery models

    not quite the same but may e relatedhttps://ideas.fabric.microsoft.com/ideas/idea/?ideaid=83567bed-3451-ec11-a3f3-281878de4cf8