sumx(
treatas(
summarize('table1', 'table1'[column1], 'table1'[column2]),
'table1'[column1], 'table1'[column2]
),
1 * related('table2'[value1])
)
the model is created in excel 2021, the table1 column [column1] and table2 [column2] have relationship. I want to get groupby table1 related table2 value1 as code. But, this defination have such error:
The column 'table2 [value1]' either does not exist or does not have a relationship to any table available in the current context
How can fix this error? or, the new defination get the correct result.
When I import this excel model to Power BI desktop, all is same.
Thank you!