Incorrect data using measure condition

Hi Anonymous

Based on your description,

&& VW_F_ACV[PRIMARY_SE] <> BLANK()

it seems like the condition is causing unexpected behavior in your measure, resulting in the same number for each SE. This issue typically arises when the measure or its condition does not correctly interact with the context of the data it's being applied to.

Here are a couple of steps to troubleshoot and potentially resolve the issue:

Review Measure Calculation: Ensure that your measure is correctly set up to calculate Open Pipeline numbers. The measure should be designed to aggregate or calculate values based on the SE (Sales Executive) context. If the measure is not correctly recognizing the SE context, it might return the same value across different SEs.

Context Transition: The issue might be related to context transition, where the filter context (in this case, not being blank) is not correctly applied to each SE.

Measure = CALCULATE(
    [YourOriginalMeasure],
    FILTER(
        ALL('VW_F_ACV'),
        VW_F_ACV[PRIMARY_SE] <> BLANK()
    )
)

Check Relationships: Ensure that there are correct relationships set up in your data model between the SE dimension and the table. Incorrect or missing relationships can lead to unexpected results when filtering or aggregating data.

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

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