Double Filter error

[Khanh1]

Im having trouble to apply my double filter year and month, so far only single year works!

The code is down below

"

Turnover - TopN:=
SUMX(
TOPN([SelectedTopNNumber],
SUMMARIZECOLUMNS(Customer[Customer Name],'Date'[Month],
"Sales TopN", CALCULATE([Amount],KEEPFILTERS(FILTER(ALL(Account[AccountTurnover]),Account[AccountTurnover]=1)))),
[Sales TopN]),
[Sales TopN])

"

The error is below:

MdxScript(xx)

Calculation error in measure 'KeyFigures' [xxx]: SummarizeColumns() and AddMissingItems() may not be used in this context

Technical Details:
RootActivityId: 30b20aca-4ffa-4508-a595-fd5ce38341f7

[v-shex-msft]

Hi @Khanh1,

I'm no so clear for your data structure, please share a pbix file with some sample data for test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng