Measure to not count customer ids at all if they have at least 1 value in a field.

[pezakas]

Hello , i have the following 3 tables:

Customer

cst_code	cst_id_surrogate	FirstN	LastN
1	151515	Mike	James
1	151516	Mike	James
2	161617	Maria	Kallas

Relational

cst_id_surrogate	plc_id_surrogate
151515	10101
151516	10102
161617	10103

Policy

plc_ID	plc_id_surrogate	Class
10001	10101	Health
10001	10102	Life
10002	10103	Health

The requirement is to create a measure that can be used as filter in order to return only they customer who dont have Class = 'Life'
In this specific scenario i expect only cst_code =2 only as a result.

Thanks in advance

[ryan_mayu]

@pezakas 

create a measure

Measure = CALCULATE(COUNTROWS(Policy),FILTER(Policy,Policy[Class]="Life"))

and add that measure to filter

pls see the attachment below

[pezakas]

Thank you for your reply, but the requirement describes the capability to return customer_ids WITHOUT having specific values in a field.

[ryan_mayu]

sry, not understand, what do you mean return id without having specific values. I think I only displayed customer id