Skip to content

Coding Hint produced flawed DAX statement #1483

@MarioMue13

Description

@MarioMue13

Description

code before:

CALCULATE(
    [ActualProductionTime],
    FILTER(
        v_FactTimeProductionData,
        RELATED( 'v_DimProductionOrder'[ProductionOrder] ) * 1 < 900000000
            || RELATED( v_DimProjectLogistic[ProjectFirstDigit] )
                IN { "7", "9" } || ISBLANK( RELATED( 'v_DimProjectLogistic'[Project] ) )
    )
)

--> coding hint: rewrite table filter as scalar preciate

after:

CALCULATE(
    [ActualProductionTime],
    KEEPFILTERS(
        RELATED( 'v_DimProductionOrder'[ProductionOrder] ) * 1 < 900000000
            || RELATED( v_DimProjectLogistic[ProjectFirstDigit] )
                IN { "7", "9" } || ISBLANK( RELATED( 'v_DimProjectLogistic'[Project] ) )
    )
)

error:

Image

Tabular Editor 3 Version

3.22.1

Screenshots

No response

Steps to Reproduce

No response

Expected behavior

No response

Crash Report

No response

Windows Version

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions