Table showing item w/o data in many-to-many relationship

[Anonymous]

Hi all,

I've have to 2 tables in many-to-many relatioship. I'd like to create a table that count the total number of customers showing item with no data

desidered Output 

Cliente	Count
x	2
blank	2

Input

Table anag:

Cliente	Spec
1	a
1	b
2	a
3	b
3	c
4	d

Table lb:

Cliente	LB
1	x
1	y
2	x
3	y
3	z

key: cliente

Suggestions?

Many thanks.

a.

[mussaenda]

May I know why the count for x 2 and for blank is also 2 and why in your desired output, Cliente has x but your x in the table is in LB column.

Please explain further

Thank you!

[Anonymous]

thanks for your interest

count distinct=2 when lb=x

count distinct=2 when lb<>x

The total number of customers in db is 4 (table anag).

a.

[mussaenda · Accepted solution]

Column = IF( 'Table2 lb'[LB] = "x", "x", BLANK())