Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to identify if value exists somewhere else in Excel table?

Hello, I have the below data table in PBI. I need to find a way to identify how many Persons have multiple Types. For example what is the # of Persons that have a 405 type and 406 type? I want to a...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    In Dax, create calculated columns

    405 = CONTAINS('Table','Table'[Type],405,'Table'[Person],'Table'[Person])
     
    406 = CONTAINS('Table','Table'[Type],406,'Table'[Person],'Table'[Person])
    407 = CONTAINS('Table','Table'[Type],407,'Table'[Person],'Table'[Person])

    and so on...

     






Anonymous's avatar
Anonymous
Not applicable
5 years ago

In Dax, create calculated columns

405 = CONTAINS('Table','Table'[Type],405,'Table'[Person],'Table'[Person])
 
406 = CONTAINS('Table','Table'[Type],406,'Table'[Person],'Table'[Person])
407 = CONTAINS('Table','Table'[Type],407,'Table'[Person],'Table'[Person])

and so on...