Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ab Ab]

Hi,

I have following columns are in data table Order, Item, Code, Qty, Country code and Tax Code.
I am trying to summarise the sum of qty each order, item and code, based on the sum of qty, I am trying to get the max qty according to the item, code by using new table. 
Also, in the new table I want get the most frequency/repeated of country and tax code according to item and code.

I want the result in New Table by using dax code (not measure) and Power Query options as well. 

I got the results by creating additional columns in Data Table but unable to apply the no blanks conditions in summary table for country code and tax code columns.

Additional column for sum qty in data table:

SUM QTY = 
CALCULATE(SUM(DATA[Qty]),FILTER(DATA,DATA[Item]=EARLIER(DATA[Item]) &&
DATA[Order] = EARLIER(DATA[Order])),
ALLEXCEPT(DATA,DATA[Item])) 

Result in New Table:

SUMMRAISE = 
SUMMARIZE(DATA,
DATA[Item], DATA[code],
“Max Qty”, MAX(DATA[SUM QTY]),
“Country Code”,MAX(DATA[Country Code]),
“Tax Code”, Max(data[Tax Code]))

Final result look like:

I want the same result (refer above mentioned snapshot) without maintain the additional columns in Data Table also apply non blanks conditions in summary table. 

https://www.dropbox.com/s/x6mc2d3ny4yp6zp/Summarise%20%284-1303%29.pbix?dl=0

——————————
Ab Ab
Engineering
——————————