Mastering DAX: How to Resolve Total Calculation Issues in Power BI
Step 1: Create a New Measure Using MaxSold. … maxsold = max(Merge1[FactInternetSales.1.SalesAmount]) Step 2: SUMX(SUMMARIZE(Merge1,DimDate[CalendarYear] ),[maxsold]) Step 3: Applying the Corrected Measure to Your Table. …