Forum Discussion

dmarkie's avatar
dmarkie
Frequent Visitor
4 years ago
Solved

MAXX Syntax and Locatin

Hi.  Newer to DAX and still learning.  I've read much and vids on Maxx but am having difficulty in achieving the desired outcome in this table creation.   I have two tables linked on the MasterID fie...
  • AilleryO's avatar
    AilleryO
    4 years ago

    No problem, sorry for not being more specific and anyway I was wrong, you should add the filter when you calulate max per MasterID, like :

    Table = 
    VAR CurrentMasterID = MAX( [MasterID] )
    VAR TempTable = FILTER (RELATEDTABLE(Detail), NOT ISBLANK('Detail'[VEHICLE ID]) && Detail[MasterID]>250 && CONTAINSSTRING(Detail[Description], "lof") )
    RETURN
    ADDCOLUMNS( TempTable , "Last Date" , CALCULATE(MAXX( 'Detail', [Date]) , MasterID = CurrentMasterID  )
     
    Let us know if it works
AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
4 years ago

You can create one more VAR to store the MasterID.

VAR CurrentMasterID = MAX( MasterID )

and add a condition to the formula for table
&&MasterID = CurrentMasterID

dmarkie's avatar
dmarkie
Frequent Visitor
4 years ago

sorry i'm not clear on the last step of adding the below condition to the formula for the table.  The only formula i have is the DAX formula we are working on.  Sorry for not understanding.

 

&&MasterID = CurrentMasterID

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    4 years ago

    No problem, sorry for not being more specific and anyway I was wrong, you should add the filter when you calulate max per MasterID, like :

    Table = 
    VAR CurrentMasterID = MAX( [MasterID] )
    VAR TempTable = FILTER (RELATEDTABLE(Detail), NOT ISBLANK('Detail'[VEHICLE ID]) && Detail[MasterID]>250 && CONTAINSSTRING(Detail[Description], "lof") )
    RETURN
    ADDCOLUMNS( TempTable , "Last Date" , CALCULATE(MAXX( 'Detail', [Date]) , MasterID = CurrentMasterID  )
     
    Let us know if it works