check if I have a value in a column for a unique identifier (depends on the value "b")

[forbi]

I have a table in which I have this information :

ID	title
ZE	a
ZE	b
ZE	c
AD	z
AD	b
BT	a
BT	e

I want to have this result by a calculated column or measure dax.

ID	title	b
ZE	a	ok
ZE	b	ok
ZE	c	ok
AD	z	ok
AD	b	ok
BT	a
BT	e

Thanks

[v-cgao-msft · Accepted solution]

Hi @forbi ,

Please try:

b = 
VAR _count_b = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALL('Table'),
        'Table'[ID] = EARLIER('Table'[ID])
        && 'Table'[title] = "b"
    )
)
VAR _result = 
IF(_count_b=1,"ok")
RETURN
_result

If [id] contains more than one "b" that also matches the condition, you can change the last judgment above from =1 to >=1.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Ahmedx]

You need to create an extra table (id table) and don't link them
identifier ok =
CALCULATE (
SELECTEDVALUE ( identifier[b] ),
TREATAS ( VALUES ( tbl[ID] ), identifier[ID] ),
TREATAS ( VALUES ( tbl[title] ), identifier[title] )
) & ""

-----
download files from here
https://dropmefiles.com/Pv33J