Making a matrix of a matrix

[Zarlot531]

So I have a SQL query that groups data the way I like, with underlying, more granular data as part of a subquery. Pretty standard stuff. But there are matrixes I like to build upon the grouped data that don't necessarily work right at the more granular level, at least not that I can see. It would be nice, however, to be able to drill down into the sub query without making a separate report tab to have the granular piece of the SQL there as a stand alone. 

Is there a way to do this? Any example PBIX files? 

[Seward12533]

As you learn more DAX  you can probalby figure out how to get the results you want, but If you really need the less granular tables or if that makes it easier to get the results you want as you learn you can easily build them either build them using M Language in the Query editor or by building tables using some simple DAX.   

I added two summarized tables in the  workbook I linked below to demonstrate.  One built by using Group By in PowerQuery and one via DAX.   You probalby want to look at the workbook to get an understanding of using multiple fact tables if your going to try to mix results from your summarized tables and your detail table.  Honestly though linking and dealing with the addional tables will probably be more difficult than taking a step back and learning how to hadle it in PowerBI through DAX.  

Here is the DAX used to create the table. (note the New Table button is on the Modeling TAB)

Summarized ITEM Transaction DAX = SUMMARIZE(Item_Transactions,Item_Transactions[SOLD_TO_BP],"Total Sales",SUM(Item_Transactions[Total Sales]),"Number of Orders",DISTINCTCOUNT(Item_Transactions[ORDER_NO]))

https://filedrop.telusa.com/message/SVRsknhPsChC0Dz7l6zcvs