Forum Discussion
Solved
Aggregation in Matrix Table
Hello 😊 I am having an issue with totals in a matrix table. I have encountered similar things before and this time looked into suggestions including building a calculated column instead of measure,...
Hi nthomson
Please try this:
Create a new table:
Table = FILTER(CROSSJOIN('USAGE','ORDERS'),'USAGE'[Product Name1]='ORDERS'[Product Name])Then add a calculate column:
Column = 'Table'[Quantity]*'Table'[Order Quantity]At last, Create a matrix:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nthomson
Please try this:
Create a new table:
Table = FILTER(CROSSJOIN('USAGE','ORDERS'),'USAGE'[Product Name1]='ORDERS'[Product Name])
Then add a calculate column:
Column = 'Table'[Quantity]*'Table'[Order Quantity]
At last, Create a matrix:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Anonymous , this has solved the issue, much appreciated!