Forum Discussion

Michael1's avatar
Michael1
Advocate II
9 years ago
Solved

CALCULATETABLE

Hello BI Community:   I am trying to calculate a table that will filter distinct records based on a single value.   My data looks like this:   Student ID Number      FName     LName     Assessm...
Tutorial Requests
  • DoubleJ's avatar
    DoubleJ
    9 years ago

    Hi Michael1

     

    You could create a column that checks wheter the current row of the student is his last assessment (you might have to replace semicolons with commas):

     

    IsLastAssessment = 
    IF(Assessments[AssNr] = MAXX(
        FILTER(
            Assessments;
            Assessments[StudentID]= EARLIER(Assessments[StudentID])
            );
         Assessments[AssNr]);
     TRUE();
     FALSE()
   )

     

    Then you can use this column to filter you visual

     

     

    I hope this helps!

    JJ

     

    BTW, I didn't know Goofy Last Name :-)

     

     

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

Hi Michael1

 

You could create a column that checks wheter the current row of the student is his last assessment (you might have to replace semicolons with commas):

 

IsLastAssessment = 
    IF(Assessments[AssNr] = MAXX(
        FILTER(
            Assessments;
            Assessments[StudentID]= EARLIER(Assessments[StudentID])
            );
         Assessments[AssNr]);
     TRUE();
     FALSE()
   )

 

Then you can use this column to filter you visual

 

 

I hope this helps!

JJ

 

BTW, I didn't know Goofy Last Name :-)

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It is Dog, I guess.. 😉