topic Re: Combine Rows in a Matrix Table in DAX Commands and Tips

Combine Rows in a Matrix Table

Luthulis — Sun, 20 Aug 2023 19:12:00 GMT

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

Re: Combine Rows in a Matrix Table

Anonymous — Tue, 22 Aug 2023 05:33:03 GMT

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

Re: Combine Rows in a Matrix Table

Luthulis — Tue, 22 Aug 2023 07:25:11 GMT

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

Re: Combine Rows in a Matrix Table

Anonymous — Thu, 31 Aug 2023 08:33:39 GMT

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

Re: Combine Rows in a Matrix Table

technolog — Sun, 24 Sep 2023 08:11:38 GMT

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.