display selected month trick not working on directquery mode

[Anonymous]

Used the calculated measure below to display current selected month in a card. Worked under import mode. But not under direct query mode. Can anyone confirm and suggest a workaround?

SelectedMonthText = if(HASONEVALUE('Date'[CalendarYearMonth]), "Selected Month " & format(FIRSTNONBLANK('Date'[CalendarYearMonth], TRUE), "MMM YYYY"), "")

[v-sihou-msft]

@Anonymous

Hi pbuser,

In Direct Query mode, to ensure that queries sent to the underlying data source have acceptable performance, limitations are imposed on measures by default.

Both FORMAT and FIRSTNONBLANK Function are not supported for use in DirectQuery mode by default. Please see: https://msdn.microsoft.com/library/mt723603(SQL.130).aspx.

Advanced users can choose to bypass this limitation by selecting File > Options and then Settings > Options > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode*. When that option is selected, any DAX expression that is valid for a measure can be used. Users must be aware, however, that some expressions that perform very well when the data is imported may result in very slow queries to the backend source when in DirectQuery mode.

Regards,

[gpraveenonline]

The performance is too slow after enabling the above settings. Any clues?