Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure or Calculated Column for filtering specific condition and comparing to original table

Here is made up data to show what I'm trying to accomplish:   TraineeId CertificationID 234 9 234   234 21 234 15 234 21 234 11 567 21...
Data Protection
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Drag TraineeID to the row labels of your visual and write this measure

    =IF(CALCULATE(COUNTROWS(Data),Data[CertificationID]="11")>0,"Yes","No")

    Hope this helps.

HotChilli's avatar
HotChilli
Community Champion
6 years ago

You could have a table to hold Trainee data , for example, DimTrainee = DISTINCT(TableCourses[TraineeID])

 

TableCourses is your ESGTrainingCoursesOnline

 

and you could add a column to show certification 11,

for example,

 

Cert11 = if (LOOKUPVALUE(TableCourses[CertificationID], TableCourses[TraineeId], DimTrainee[TraineeId], TableCourses[CertificationID], 11) = 11, "Yes", "No")