Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

Dax error

Hi Experts

 

see the below error I am getting, how do I modify this code?

 

 

Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, vjnvinod 

    You can try this to see if it solves your problem.

    3M Weightage filter =
CALCULATE (
    MAX ( 'People Flash Consolidated'[Month Rank] ) - 2
        && MAX ( 'People Flash Consolidated'[Weeknumber] )
)

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

    Best Regards,

    Community Support Team _ Charlotte 

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

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    4 years ago

    Hi, vjnvinod 

    You can try this to see if it solves your problem.

    3M Weightage filter =
CALCULATE (
    MAX ( 'People Flash Consolidated'[Month Rank] ) - 2
        && MAX ( 'People Flash Consolidated'[Weeknumber] )
)

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

    Best Regards,

    Community Support Team _ Charlotte 

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