Creating measure for count of occurrence of the value of one column in a different table.

[PowerBEye1]

Hi everyone,

I'm working on creating a PowerBI reporting analyzing incident data. I'm trying to calculate how many times a value in Table 1 Column 1 occurs in column 2 Table 2. I am struggling with the values that have multiple "Tactics".
Based on the tables in the screenshot I am looking for an output like below

IntialAccess	2
Discovery	1
Exfiltration	1

Hopefully there is an easy answer I am not seeing.

Thanks!

[v-xiaotang · Accepted solution]

Hi @PowerBEye1 

Please try this measure

count = CALCULATE(COUNTROWS('Table'),FILTER('Table',CONTAINSSTRING('Table'[Tactic],MAX(List[Column1]))))

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

@PowerBEye1 

suggest first to split the Tactic column in Table 2 into rows in Power Query. Check this:

https://learn.microsoft.com/en-us/power-query/split-columns-delimiter