topic how to convert calculated column measure to measure in DAX Commands and Tips

how to convert calculated column measure to measure

ShaRaj — Tue, 17 Jan 2023 13:59:55 GMT

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

Re: how to convert calculated column measure to measure

amitchandak — Tue, 17 Jan 2023 15:15:39 GMT

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

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

Re: how to convert calculated column measure to measure

ShaRaj — Wed, 18 Jan 2023 06:30:44 GMT

Hi ,

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

Re: how to convert calculated column measure to measure

Anonymous — Wed, 18 Jan 2023 09:28:52 GMT

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.