Incorrect data using measure condition

[Anonymous]

Hi All,

I'm stuck at a measure where its not working as intended. I'm trying to check my Open Pipeline numbers against each SE but strangely my measure is giving the same number for each SE. 

What exactly I'm doing wrong here??

Also if I remove the below condition then it is giving correct number but I want the condition to be there. 

&& VW_F_ACV[PRIMARY_SE] <> BLANK())

[Anonymous]

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.

[Daniel29195]

@Anonymous 

is it possible that you could share the power bi file to take a look ?