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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.

  • NikoMendez's avatar
    NikoMendez
    Frequent Visitor
    6 years ago

    Hi..

     

    I agree with Ashish_Mathur  (I was just posting the same formula 😉 ) and I think that is the one to use.

     

    I'd just add, that you can use it as Calculated column or measure. If you need to use a slicer with YES/NO selection create a calculated column, otherwise, create a measure..