Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ShaRaj
Frequent Visitor

how to convert calculated column measure to measure

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
1 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.

View solution in original post

3 REPLIES 3
ShaRaj
Frequent Visitor

Hi ,

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

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
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors