help with slicer selector

[snifer]

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"

[v-chuncz-msft · Accepted solution]

@snifer,

Try to add an OR condition.

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