Forum Discussion

HanishR's avatar
HanishR
Frequent Visitor
6 years ago
Solved

Incorrect total in Matrix Total

I have a Matrix with a currency conversion in place for the Values,  The currency conversion rate is picked up by the following formula:  TRNRate = MIN('Currency Table'[Exchange Rate]) Where my ex...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi HanishR ，

    Please try to update your measure with the below formula and applied this new created measure on the visual to replace measure Sales Converted:

    Measure=SUMX(VALUES('TABLE'[Category]),SUMX(VALUES('TABLE'[COUNTRY]),[Sales Converted]))

    Or you can refer the contents in the following links to update the formula of your measure and get the correct results:

    Totals incorrect

    Why Your Total Is Incorrect In Power BI

    If the above methods can't help you, you can provide some sample data which applied on the visual and existed relationship if the data from multiple tables.

    Best Regards

    Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi HanishR ，

Please try to update your measure with the below formula and applied this new created measure on the visual to replace measure Sales Converted:

Measure=SUMX(VALUES('TABLE'[Category]),SUMX(VALUES('TABLE'[COUNTRY]),[Sales Converted]))

Or you can refer the contents in the following links to update the formula of your measure and get the correct results:

Totals incorrect

Why Your Total Is Incorrect In Power BI

If the above methods can't help you, you can provide some sample data which applied on the visual and existed relationship if the data from multiple tables.

Best Regards

Rena