Dax Query

[Fsciencetech]

Hi folks,

I have an dax code which is running will in dax editor, the same thing I want to run on my PBI but throwing error

"Calculation error in measure 'Sales[Max GA%]: SummarizeColumns() and AddMissingItems() may not be used in this context"

Dax Editor :

DEFINE
VAR FinalTable = 
    SUMMARIZECOLUMNS(Sales[YearQtr], Sales[BrandCode Group], 
        FILTER(KEEPFILTERS(VALUES('Sales'[BrandCode Group])), 'Sales'[BrandCode Group] <> "PCSD"), 
        "GA_Mix_", 'Sales'[GA Mix%])      ---- Using Measure pre calculated Mix%

  VAR TopBrandValue = 
       TOPN(1, FinalTable, [GA_Mix_], 0)

  VAR Result = 
    SUMMARIZECOLUMNS(
      Sales[BrandCode Group], Sales[YearQtr],    
      TopBrandValue,
      "GA_Mix_", 'Sales'[GA Mix%]
    )
EVALUATE
  GROUPBY(Result, "MinGA_Mix_", MINX(CURRENTGROUP(), [GA_Mix_]))

I want to same dax on PBI.

[amitchandak]

@Fsciencetech , Try if you can do same with Addcolumns(Summarize in place of summarize columns  

Refer for example 

Solved: Issue with Bar chart: SummarizeColumns() and AddMi... - Microsoft Power BI Community

also refer

Power Pivot Principles: The A to Z of DAX Functions - ADDMISSINGITEMS < Article < Blog | SumProduct ...