how to convert calculated column measure to measure

[ShaRaj]

hi

iam getting error while converting calculated  measure in to dax measure, i tried without earlier also.

max = MAXX(FILTER('Score Fact Table','Score Fact Table'[CalYear]=Earlier([CalYear]) && 'Score Fact Table'[Category]=Earlier([Category] ) && 'Score Fact Table'[Sub Category]= EARLIER('Score Fact Table'[Sub Category])),'Score Fact Table'[Value]) 

ThanksInAdvance

[ShaRaj]

Hi ,

iam not getting  desired output. instead of taking max of each category for every year ,this returns max value  of that particular column

[v-rzhou-msft · Accepted solution]

Hi, @ShaRaj ,

Please make sure whether you use this code to create a measure instead of a column.

As far as I know, you just need to change EARLIER() to MAX()/SUM() in measure. MAX() for text data and SUM() for number data.

max1 = 
MAXX (
    FILTER (
        'Score Fact Table',
        'Score Fact Table'[CalYear] = MAX ( [CalYear] )
            && 'Score Fact Table'[Category] = MAX ( [Category] )
            && 'Score Fact Table'[Sub Category] = MAX ( 'Score Fact Table'[Sub Category] )
    ),
    'Score Fact Table'[Value]
)

Best Regards,
Rico Zhou

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

[amitchandak]

@ShaRaj , try like

max = MAXX(FILTER(allselected('Score Fact Table'),'Score Fact Table'[CalYear]=max([CalYear])
&& 'Score Fact Table'[Category]=max([Category] )
&& 'Score Fact Table'[Sub Category]= max('Score Fact Table'[Sub Category])),
'Score Fact Table'[Value]) 

or

max = MAXX(FILTER(all('Score Fact Table'),'Score Fact Table'[CalYear]=max([CalYear])
&& 'Score Fact Table'[Category]=max([Category] )
&& 'Score Fact Table'[Sub Category]= max('Score Fact Table'[Sub Category])),
'Score Fact Table'[Value])