Using COUNTROWS to find the amount of times the given [Code] appears in a table

[toneradeu]

Greetings, I started using Power BI recently, so I don't have experience in DAX, and i'm stuck in a problem that i can't really think of a solution.

• I have this gigantic table called 'fResponsib' which have a Column named [Responsibility_Name].
• I also have a Table called 'DimEnt', which has 2 columns: [Code] and [Flag].
• I need to create an column called [Qty] in 'DimEnt, which is the sum of all the times [Code] has appeared in [Responsibility_Name].
• Both [Code] and [Responsibility_Name] are text-values.

Here's what i had in mind:

Code	Flag	Qty
F4XX45	Type-A	813
F4XX06	Type-B	755
F4XX15	Type-C	9
F4XX87	Type-D	114
F4XX33	Type-E	887
	Other	33133

What I tried to do:

Qty = COUNTROWS( CALCULATETABLE('fResponsib', CONTAINSSTRING('fResponsib'[Responsibility_Name],'DimEnt'[Code])))

What should I do in this situation?
Thanks in advance!

[Fowmy · Accepted solution]

@toneradeu 

Can you try this as a new column?

Qty = 
COUNTROWS( 
    FILTER(
        'fResponsib',
        CONTAINSSTRING('fResponsib'[Responsibility_Name],EARLIER([Code]))
    )
)