Forum Discussion

nthomson's avatar
nthomson
Frequent Visitor
2 years ago
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,...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi nthomson 

 

Please try this:

I create 3 table at first:

The relationship:

 

Then add a measure:

Measure = MAX('ORDERS'[Qty])*MAX('PARTS'[Usage per product])

The result is as follow:

If the above one can't help you, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

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.