Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Formula Error

Hi Experts

 

I cannot see my error in the following DAX

MColumn = 
Calculate(Max('P' [MColumn]),FILTER('P,'P' [Curve] = Input[Curve] &&
'P,'P' [Product] = Input[Product]))

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    I am not quite sure about what you are trying to analyze by your measure, but please try something like the below.

     

    MColumn =
    CALCULATE (
    MAX ( 'P'[MColumn] ),
    FILTER ( 'P', 'P'[Curve] = Input[Curve] && 'P'[Product] = Input[Product] )
    )

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , small changes

     

    MColumn =
    Calculate(Max('P'[MColumn]),FILTER('P','P'[Curve] = Input[Curve] && 'P'[Product] = Input[Product]))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      What Changes Amit?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    I am not quite sure about what you are trying to analyze by your measure, but please try something like the below.

     

    MColumn =
    CALCULATE (
    MAX ( 'P'[MColumn] ),
    FILTER ( 'P', 'P'[Curve] = Input[Curve] && 'P'[Product] = Input[Product] )
    )

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM