Can I build a matrix on the value of another matrix?

[SVOHio]

Is it possible for me to build a matrix from the value of another?

What I'm trying to do: Below displays a mockup of a 3rd matrix (bottom right) of what I would like to do, where the Destination Channel value of the top matrix drives the filtering of the 3rd. The second caveat is that a Source could have multiple Destination Channels. So, I'm uncertain how I may do this and looking for some thoughts, insights? I haven't worked with any DAX yet, but I wasn't sure if it was possible, and if so, would it be through DAX, creation of a Dimension table and relationship, combination, or what exactly. Sorry for the crudenes of my example, but my data is confidential which is why these say "dummy", like me. 🙂

What I have done: I figure someone has tried this and I have searched for articles or tutorials, but most were about creating a matrix, not linking them so-to-speak in the manner I'm asking. The closest I arrived was the slicer you see sorting the two matrices (top and bottom) by a single value, but not how to drive another matrix based on the value of another. An example may be out there, I just hadn't come across it yet.

The Data: I have two Fact tables. The 1st Fact table provides the Source to Destination relationship you see in the top matrix, the 2nd Fact Table provides all the intricate details for Source and Destination I'm trying to capture in my mockup (bottom two matrix). I had to create a de-duped Source Dimension table for the Source and I have a de-duped one for the Destination, but I'm not sure how to incorporate the Destination in this scenario... if I can at all.

[lbendlin]

A matrix is (like any other visual) based on an underlying DAX query. In your new matrix use measures that implement the same DAX.

[SVOHio]

So it sounds as if I need to learn how to use DAX. I'm 2 weeks new to Power BI, so trying to learn.

[SVOHio]

I've tried working on this for a month and I'm not getting anywhere with it, even with other "similar solution posts" on this site. I'm not sure why this is so complicated. I just want to use a value from the slicer filtered results of Matrix 1 and have Matrix 2 pull related table values on that value for Matrix 2. I've tried creating measures, tables and using DAX functions. I'm just at a loss?

[lbendlin]

Use the Performance Monitor to harvest the DAX query for the first matrix.  Then use that as the basis for the second matrix.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...