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 ...
  • parry2k's avatar
    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! ❤️