TOPN inside Calculate (Query Fragment Error)

[Manar]

I am trying to calculate the average of Exchange Rate for the las 12 periods (ReportingPeriod varchar(6)), So I wrote the following:

Measure 2 = calculate(AVERAGE(ExchangeRatesFacts[ExchangeRate]),TOPN(12,ExchangeRatesFacts,ExchangeRatesFacts[ReportingPeriod]))--- I am using Direct Mode

and when I try to put hte measure2 in any visual I get a weird error message:

Any help is appreciated.

Thank you

[v-yulgu-msft · Accepted solution]

Hi @Manar,

Based on my test, TOPN is not supported in Direct Query mode.

Regards,

Yuliana Gu