Count occurrences based on lookup table and a category in it

[Lobo1908]

Hi, 

I've got a table with bunch of codes. 

Now I need a measure to count those codes but only the one that have a specific condition which is assigned to each code in a lookup table. 

My data table looks like that. 

Code

A1

B1

C1

A1

B1

C1

A1

B1

C1

A1

A1

D1

C1

C1

A1

D1

My lookup table like this

Code	Condition
A1	New
B1	New
C1	Old
D1	Old

And for example I want to count only the one that have 'New' as Condition in the loopu table 

 so the results hsoulkd be:

A1 - 6

B1 - 3

Could nayone support please 

[HotChilli]

create a relationship between lookup table and the main table (on code).

Drag Code field from the lookup on to a table visual, drag code from the main table on to the same visual.  Make the second one a Count aggregation.

Put Condition from the lookup table in a slicer

[Lobo1908]

Hi @HotChilli ,

I know how to present those values in a table or matrix. 

I require a measure for further calculations