Column Reference in the All function

[Sureshbabu_1995]

Summarized the external table with some columns and i need to refer the one of the summarized column in the All function within the Calculate function of the Summarized table
SUMMARIZE(
FILTER( Table1,Table1[MeasureCategory]="ABC"
),
Table1[x],
Table1[y],
Table1[MeasureCategory],
Table1[z],
"ClaimPeriod"," ",
"Category", " ",
"Axis","Total",
"Value", CALCULATE(SUM(Table1[Sales]),
Table1[MeasureCategory]="ABC",ALL('Table2'[ClaimPeriod]),ALL( )---need to refer the above claim period in the All function
)

[Bibiano_Geraldo]

Hi @Sureshbabu_1995 ,
You can't directly refer to the new column names (e.g., "ClaimPeriod", "Category", "Axis") in the ALL function because those columns are created dynamically in the SUMMARIZE function. The 'ClaimPeriod' column inside the SUMMARIZE function is only a placeholder value and doesn't represent a real column. You can't directly refer to the column names in the ALL function that were created in SUMMARIZE.

[TomMartens]

Hey @Sureshbabu_1995 ,

provide the DAX code you have, I have no idea what the above is about, I also do not know what you mean by external table.
Consider creating a pbix file representing your semantic model (tables, relationships, calculated columns, and measures), upload the pbix to OneDrive, Google Drive, or Dropbox, and share the link. Make sure that the link accepts anonymous logins.

Do not forget to explain the expected result based on the data you provide.

Regards,
Tom

[ajaybabuinturi]

Hi @Sureshbabu_1995 ,

Could you please provide more deatils about request?