Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (31) 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 (2)
    Tibo's profile image Profile Picture

    Andreu fil on 19 Apr 2024 17:54:09

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

    Good information, thankssehackear.top

    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