DAX Formula Error

[Anonymous]

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]))

[Jihwan_Kim · Accepted solution]

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

[amitchandak]

@Anonymous , small changes

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

[Anonymous]

What Changes Amit?