how to identify differences in a group of rows vs other group of rows

[Danielecc]

Hello everyone,

Each group of "family" always has only one "Supplier" that we must identify because all the other "member" of that "Family" must be equal to the "Supplier" (same number of rows and same values) in the Columns "Item", "Data" and "Value".

The result expected is only one of this (not include the "explanation why here"):

The table data in text mode is:

FAMILY	Member	Title	Item	Data	Value
Family1	Father_X	Supplier	Country	Chile	10
Family1	Father_X	Supplier	Address	Los Duraznos St.	101
Family1	DaughterX1	Not_Supplier	Country	Chile	10
Family1	DaughterX1	Not_Supplier	Address	Los Duraznos St.	101
Family1	DaughterX2	Not_Supplier	Country	Chile	10
Family1	DaughterX2	Not_Supplier	Address	Los Duraznos St.	101
Family2	Father_Y	Supplier	Country	EEUU	10
Family2	Father_Y	Supplier	Entry	Amount	$3.500
Family2	Father_Y	Supplier	Address	California St.	240
Family2	Father_Y	Supplier	Other	Number	3
Family2	Wife_Y	Not_Supplier	Country	EEUU	10
Family2	Wife_Y	Not_Supplier	Entry	Amount	$3.500
Family2	Wife_Y	Not_Supplier	Address	California St.	240
Family2	Son_Y	Not_Supplier	Country	EEUU	10
Family2	Son_Y	Not_Supplier	Entry	Amount	$3.500
Family2	Son_Y	Not_Supplier	Address	California St.	240
Family2	Son_Y	Not_Supplier	Other	Number	3
Family2	Son_Y	Not_Supplier	Job	YES	Engineer
Family3	Mother_Z	Supplier	Country	korea	10
Family3	Mother_Z	Supplier	Entry	Amount	$3.000
Family3	Mother_Z	Supplier	Address	HingYoo St	628
Family3	DaughterZ	Not_Supplier	Country	China	10
Family3	DaughterZ	Not_Supplier	Entry	Amount	$3.000
Family3	DaughterZ	Not_Supplier	Address	HingYoo St	400

Thanks a lot for your help...best regards.

[smpa01]

@Danielecc  what is the desired output for this dataset?

[Danielecc]

Hi @smpa01  thanks for see the post.

My desired output is a new table with one of this options:

One of that two options is ok, but is better the advanced option 🙂  

Thanks again and best regards.

[amitchandak]

@Danielecc ,

New column =

var _1 = countx(filter(Table,[FAMILY] = earlier([FAMILY])  &&  [Title] = "Supplier" ), [Title] )+0

return

if(_1>0, "Supplier", [Title] )

[Danielecc]

Hi @amitchandak , first of all thanks a lot for your answer.

The result of that DAX was:

Best Regards...