Forum Discussion
Solved
Measures with Sum in Matrix Rows
Hi all - I have a Matrix visual showing inventory liquidation data. The rows come from a pre-aggregated fact table. Filtering works fine for 1:1 relationships (stocked month to inventory), but break...
Hi matt_campbell ,
Please find attached snap and PBIX file.
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
How is your pre-aggregated fact table linked to row-level fact table?
Also, could you explain how the matrix visual works (how each cell is calculated)? That might help others figure out how to build the solution.
Thank you for the reply. The tables are linked by Last_Date_Of_Month. I have updated the original post which I left out that column. The matrix cells are the Count Sold divided by Inventory Stocked for the row. The cells can also show Count. Here is a view of count.