Row totals are duplicating, Grand Total is Correct
I have an issue where the row totals are overstated but the grand total is correct. The source is a tabular model and when I connect Excel to the model in a pivot table, everything is correct but for some reason Power BI is duplicating the row totals. The underlying measure is a SUMX. Any ideas on what might be going on?