Forum Discussion

blithechan's avatar
blithechan
Advocate I
8 years ago
Solved

DAX Function CONCATENATEX is not supported on PBIRS / DirectQuery Mode

Hi all,   I tried to use DAX function CONCATENATEX using DirectQuery mode. It works fine on PBI Desktop. But when I run the report on on-prem PBIRS, the following error message "Function CONCANTENA...
CONCATENATEX
DAX
PBIRS
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Hmm, yeah for something simple like that you could do something like:

     

    Measure = 
MAXX(FILTER('#Currencies',[Currency]="HKD"),[Currency]) & "," &
MAXX(FILTER('#Currencies',[Currency]="USD"),[Currency]) & "," &
MAXX(FILTER('#Currencies',[Currency]="RMB"),[Currency])

    But that's really not any better than just creating a measure that is = "HKD,USD,RMB" and I assume this is a small subset of your data.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Hmm, yeah for something simple like that you could do something like:

 

Measure = 
MAXX(FILTER('#Currencies',[Currency]="HKD"),[Currency]) & "," &
MAXX(FILTER('#Currencies',[Currency]="USD"),[Currency]) & "," &
MAXX(FILTER('#Currencies',[Currency]="RMB"),[Currency])

But that's really not any better than just creating a measure that is = "HKD,USD,RMB" and I assume this is a small subset of your data.

blithechan's avatar
blithechan
Advocate I
8 years ago

Thanks Greg for suggesting MAXX function. It serves the purpose well.