How to solve Error Out of present Range in Power BI (DAX formula)

[Peter_Price]

Hi Folks,

I have tried to fix the out of present range problem in Power Bi Dax formula General background I have a data-set as below,

Link : Image Link

the dashboard allows user to select the preferred currency and then the table update the value. For example , if click on US, then the table sum all Sales in Jan from US as well

as showing $ or € accordingly

The DAX function i have tried is

CONCATENATE( Table[Country]="US", "$",FORMAT(sum(Table[Sales]),"0") but it comes up with below

Link : Image Link

Any help please. thanks

[Anonymous · Accepted solution]

Hi @Peter_Price,

Obviously, you are wrong with CONCATENATE function, it not support there merge values which you wired.

Reference links:

CONCATENATE Function

Joins two text strings into one text string.
CONCATENATE(<text1>, <text2>)

You can use below measure to achieve your requirement:

Measure =
VAR currCounty =
    SELECTEDVALUE ( Table[Country] )
VAR _symbol =
    SWITCH ( currCounty, "US", "$", "EUR", "€", "UK", "£", "$" )
RETURN
    _symbol & CALCULATE ( SUM ( Table[Sales] ), VALUES ( Table[Country] ) )

Regards,

Xiaoxin Sheng

[Peter_Price]

it works perfectly, thx XiaoXin