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.

amitchandak's avatar
amitchandak
Super User
6 years ago

On the same table, you can lookup and flag

 

Cert 11 column = if(ISBLANK(LOOKUPVALUE(Sheet1[TraineeId],Sheet1[CertificationID],11,Sheet1[TraineeId],FIRSTNONBLANK(Sheet1[TraineeId],TRUE()),firstnonblank(Sheet1[TraineeId],true()))),"No","Yes")

 

Link : https://www.dropbox.com/s/e447c2jnwp54p95/certificate.pbix?dl=0

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601