topic Creating measure for count of occurrence of the value of one column in a different table. in DAX Commands and Tips

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

PowerBEye1 — Tue, 22 Nov 2022 21:00:57 GMT

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!

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

FreemanZ — Tue, 22 Nov 2022 21:39:12 GMT

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

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

v-xiaotang — Fri, 02 Dec 2022 09:30:52 GMT

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.