Using Power BI Desktop I’ve created a table below, now I want to recreate this table based on the max value of total purchase per country
Northwind has been used for this example, meaning the Customers and Order Details tables are from the Microsoft Northwind sample database.
the last column of the table was derived from the calculation of the Order Details table:
Total Purchase = Calculate(SUMX(‘Sales Order Details’, [UnitPrice] * [Quantity])).