Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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.
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.
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
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |