Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

help with slicer selector

I create a table to be a slicer for select currency in my matrix

 

all working good using this code

 

Measure-Total2 =
IF (
SELECTEDVALUE ( CurrencySelector[value] ) = "Local Currency",
SUMX ( FILTER ( 'UploadAccountsCurrentyPeriod', UploadAccountsCurrentyPeriod[Currency selector] = "Local currency" ), UploadAccountsCurrentyPeriod[-amount] ),
 
SUM(UploadAccountsCurrentyPeriod[TotalAmountDKK])
)+0
 
the only issue is  when the company currently is DKK and i select "local currency" everything getting 0 ( since local currency =DKK)
 
how I can change the code before assuming that
If UploadAccountsCurrentyPeriod[Currency selector] = "dkk" and SELECTEDVALUE ( CurrencySelector[value] ) = "Local Currency"
display "local currency"
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Try to add an OR condition.

            FILTER (
            'UploadAccountsCurrentyPeriod',
            UploadAccountsCurrentyPeriod[Currency selector] = "Local currency"
                || UploadAccountsCurrentyPeriod[Currency selector] = "dkk"
        )

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    7 years ago

    Anonymous,

     

    Try to add an OR condition.

            FILTER (
            'UploadAccountsCurrentyPeriod',
            UploadAccountsCurrentyPeriod[Currency selector] = "Local currency"
                || UploadAccountsCurrentyPeriod[Currency selector] = "dkk"
        )