[Newbie] Rearranging data structure into a new table

Dear DAX users,

I am relatively new to PowerBi, and I am trying to rework some data from a Sharepoint list. Basically I have a list of users from various divisions that are allocated to one or more actions.

The original Sharepoint list looks like:

I have already created a powerquery that brings this dataset into PowerBi with the actions broken down

I would like to manipulate those data into a new table where I can see the coverage of actions by division, to highlight which actions are covered by whom. I would like to obtain something like:

This way I would later by able to report how much divisions are involved with actions by the table with name count and/or a heatmap.

I have tried looking into PowerBi documentation, several DAX articles and even tried several CoPilot prompts to generate some baseline DAX code, but after 3 hours banging my head I have to raise a white flag... Would anyone have an idea how to proceed?

Thanks in advance