Forum Discussion

Luthulis's avatar
Luthulis
Frequent Visitor
3 years ago

Combine Rows in a Matrix Table

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 

DAX
matrix
new column

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Luthulis's avatar
    Luthulis
    Frequent Visitor
    3 years ago

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

  • technolog's avatar
    technolog
    Super User
    2 years ago

    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.