Matrix tables and incorrect subtotals and totals summarizing from multiple tables

[CLAK-2023]

Matrix table is coming up with VERY large incorrect values.  I've search the web and tried all kinds of suggestions to no avail.   The problem is coming up with a Dax for a novice summarizing on 2 separate tables.  Below is my arch enemy....

Good Luck!

[Anonymous]

Hi @CLAK-2023 ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards

Yilong Zhou

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

[johnt75]

Try 

FC 2024 FR Abs =
VAR _SummaryTable =
    SUMMARIZE ( 'Rates', 'Location'[Location], 'Rates'[Rate Type] )
VAR Result =
    SUMX (
        _SummaryTable,
        [2024 Abs Qty] * CALCULATE ( SUM ( 'ABS 2024 FR Rate'[USD Price *1] ) )
    )
RETURN
    Result

You should be able to do the same SUMX over SUMMARIZE for the other measure too.