undefined

[Anonymous]

Hi, I have a tableau measure like this:

IF [Rating Projection Year 1] = 2021
THEN SUM([Weights Ly]*[Next year rating predicted (1)]*[Inclusion Flag Ly])/SUM([Weights Ly]*[Inclusion Flag Ly])
ELSEIF [Rating Projection Year 1] = 2022
THEN SUM([Weights Cy]*[Next year rating predicted (1)]*[Inclusion Flag Cy])/SUM([Weights Cy]*[Inclusion Flag Cy])
ELSE 0
END

I tried to replicate it using the below DAX command:
IF ([Rating Year Projection 1 Value] = 2021,SUMX('Table',[Weights Ly]*[Next year rating predicted (1) pbi]*[Inclusion Flag Ly])/SUMX('Table',[Weights Ly]*[Inclusion Flag Ly]),IF ( [Rating Year Projection 1 Value] = 2022,SUMX('Table',[Weights Cy]*[Next year rating predicted (1) pbi]*[Inclusion Flag Cy])/SUMX('Table',[Weights Cy]*[Inclusion Flag Cy]), 0))

Somehow, the output is not right, any help is appreciated.

[amitchandak · Accepted solution]

@Anonymous , if this is column([Rating Year Projection 1 Value])  then you need to use max

IF (max([Rating Year Projection 1 Value]) = 2021,SUMX('Table',[Weights Ly]*[Next year rating predicted (1) pbi]*[Inclusion Flag Ly])/SUMX('Table',[Weights Ly]*[Inclusion Flag Ly]),
IF ( max([Rating Year Projection 1 Value]) = 2022,SUMX('Table',[Weights Cy]*[Next year rating predicted (1) pbi]*[Inclusion Flag Cy])/SUMX('Table',[Weights Cy]*[Inclusion Flag Cy]), 0))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.