Forum Discussion

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support

    Hi Analitika ,

     

    _Stock = 
    IF (
        ISFILTERED ( 'Category'[short] ),
        CALCULATE (
            [_EUR, end],
            FILTER (
                VALUES ( 'pre_kod BRIDGE'[PRE_KOD] ),
                COUNTROWS (
                    FILTER (
                        'Category',
                        [_categories]='Category'[short]
                    )
                ) > 0
            )
        )
    )

    The context of this measure contains pre_kod BRIDGE'[PRE_KOD] columns, and there is no relationship between the pre_kod BRIDGE table and Category table. The context environment will affect measure, while the actual column will not be affected by selecting measure.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.