Forum Discussion

Fsciencetech's avatar
Fsciencetech
Helper III
4 years ago

Dax Query

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.