Combine Rows in a Matrix Table

[Luthulis]

Help I want to combine quantity rows into one row.

For Example (What I know):

If selected BatchNo is Batch-202 & Batch-203. I will take the (Max) ActualValue for each BatchNo then Sum it and replace the old value with the new calculated value. Then my Matrix table will combine these numbers. I already have a table that have a maximum value for each BatchNo (if it is useful).

Condition:

Only for Quantity or when Order = 2.

pbx file and sample data attached.

PowerBISample 

[technolog]

I hope this message finds you well. I've noticed that this solution remain unresolved. If any of you have managed to find a resolution to the issue, I kindly request that you share your solution for the benefit of the entire community. Alternatively, if you're still facing challenges, please do let us know as well.

Your insights and updates will greatly assist others who might be encountering the same challenge.

[Luthulis]

No this does not solve the problem. Your attempt is appriciated.

[Anonymous]

Hi @Luthulis ,

For your needs, I can't think of a better way to accomplish it. Please check the blog below if its available as a workaround.

How to put the row and column subtotals in front o... - Microsoft Fabric Community

Best Regards

[Anonymous]

Hi @Luthulis ,

If I understand correctly, you're trying to combine two rows of data with label Quantity and brand no. Batch-202 & Batch-203 into one row. I reviewed your file and you put the field [ActualValue] on the Rows option of Matrix. I'm afraid I won't be able to fulfill your needs. The field which can be put on Rows option of matrix is a fact field or a calculated column. Since it is a fact field or calculated column, then there is no way to dynamically display the value. Perhaps you might consider creating a measure that calculates the actual value based on your criteria and then putting it in the value column. The problem with this is that the values of all labels are combined and appear under each package label... 

Best Regards