Forum Discussion

A_a_a's avatar
A_a_a
Helper III
3 years ago
Solved

Incorrect Total in Matrix Table

Hi All,   I know that this topic was discussed many times, but still I cannot get the correct Totals...   Subtotals are correct, but Totals are not...   Please see my calculations. The matrix ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    A_a_a your measure should be just this:

     

    Measure 0 = 
VAR __result = 

        SUMX (
            SUMMARIZE (
                'Actual Table',
                dim_product[Product],
                dim_date[Week],
                "@Cal", [Calculations]
            ),
            [@Cal]
        )

RETURN
__result

     

    👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

    If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

parry2k's avatar
parry2k
Super User
3 years ago

A_a_a whatever your transaction table is on which you are writing the measure.

 

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

  • A_a_a's avatar
    A_a_a
    Helper III
    3 years ago

    Hi parry2k 

     

    Thank you for your message.

    This is what I thought, but again I have an incorrect figure in Totals. 

     

    I am wondering that maybe it is due to the Calculation measure, which is based on two different tables.

     

    Calculations = DIVIDE([A],[C],0)-DIVIDE([B],[C],0)

     

     [A] and [C] are taken from one table and [B] from another one.

     

    Please let me know what you think.

     

    G.