Forum Discussion

JorgeCervantes's avatar
JorgeCervantes
Frequent Visitor
1 year ago
Solved

I need help displaying information over a Matrix Table

Hi Everyone, 

 

I hope to find you all well, I have the following table:

 

Part NumberLast PriceStandard PriceVolumeBalance

Part 1

10910-10
Part 211131530
Part 312108-16
Totals333233X

 

If I leave the measurement be, the balance will do the totals calculation:  

 

(32-33) * 33 = -33

 

Which is not correct. So, last time, the problem was that the balance was not calculating correctly, I did some digging and found the solution was to add a SUMX expression to a different calculation, somthing like this: 

Final Measure = SUMX(Table, Original Measure)

 

I feel I have to give full context so that we are all on the same page, the exercise I'm doing is the calculation of the cost of materials in my plant, so we have last prices every month, I made a calculation so that whenever you chose a date it will always give you the last price. So now we basically have all the pieces of the puzzle, I just need one more things.

 

I need the final results on a Matrix Table, something like this

 

CategoryJanFebMar...
ImpactFinal Result JanuaryFinal Result FebruaryFinal Result MarchFinal Result for the Remaining Months

 

Does anyone know how to do this?

 

Thank you. Best Regards

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JorgeCervantes ,

     

    As far as I know, if the [Month] column is related to your data table, the balance measure should work. You can also try SUMX() function.

    Balance = SUMX('Table',('Table'[Standard Price] - 'Table'[Last Price]) * 'Table'[Volume])

    My Sample:

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi JorgeCervantes ,

     

    As far as I know, if the [Month] column is related to your data table, the balance measure should work. You can also try SUMX() function.

    Balance = SUMX('Table',('Table'[Standard Price] - 'Table'[Last Price]) * 'Table'[Volume])

    My Sample:

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.