Is Value in other table for this case existing?

[DWilming]

Hi, 

maybe a simple question. 

I have two tables. 

One contains a lot log information for each ID number. 

ID	Subject
10218672	General
10218672	General
10219335	Case A
10229051	Case A
10229051	Case A
10229051	Case A
10229051	Case B
10231987	Case A
10232341	Case A
10232609	General
10233454	Case A
10233454	Case B
10233669	Case B
10233677	Case A
10233677	Case A
10233677	Case A
10233678	Case A
10233678	Case B
10233686	Case A
10233686	Case A
10233686	Case A
10233686	Case B
10233686	Case B
10233694	Case A
10233694	Case A
10233694	Case A
10233694	Case A
10233694	Case A
10234320	Case B

In my second table, I would like to have a column which shows me, if "Case B" is in the log file for the specific ID No.

ID	Check for Case B
10218672
10219335
10229051	existing
10231987
10232341
10232609
10233454	existing
10233669	existing
10233677
10233678	existing
10233686	existing
10233694
10234320	existing

Any idea how the DAX formula for column "Check for Case B" would look like. 

Thanks in advance.

[AlB · Accepted solution]

Hi @DWilming 

Check for Case B =
IF ( CALCULATE ( COUNT ( Table1[ID] ), Table1[ID] = "Case B" ) > 0, "Existing" )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers