Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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 aggregate this for every Type (405,406,407,408).

 

Maybe four columns titled "In 405?", "In 406?", "In 407?", "In 408?" for each row that has Yes/No values.



Person       Type

Person 1405
Person 1406
Person 2406
Person 2407
Person 2408
Person 3407
Person 3408
1 ACCEPTED SOLUTION
Anonymous
Not applicable

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...
Karlos_0-1616195805365.png

 






View solution in original post

1 REPLY 1
Anonymous
Not applicable

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...
Karlos_0-1616195805365.png

 






Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.