create a currency slicers with multiple rates

[MK_Aqipa]

Hi,

I'm trying to create a currency slicer with multiple exchange rates (on a monthly basis). 

I've tried the following formula: 

Applicable Exchange Rate = CALCULATE(VALUES(Tabelle1[FX Rate]);FILTER(ALLEXCEPT(Tabelle1;Tabelle1[FCURR]);Tabelle1[TCURR]= SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[waers]) && Tabelle1[Period - Date Format] = SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[jjjjmm])))

Revenue in Selected Currency = [Applicable Exchange Rate]*SELECTEDVALUE('viewBI JJJJMM01_kunde_marke_lc'[ums])

however it does not work. Anybody has an idea?

And would it be possible to combine the currency slicer for further measures on the same workbook (f.e. not only slicer for revenue, but also for the order amount, costs,...)?

Thanks a lot for your help,

Regards

[v-yuezhe-msft]

@MK_Aqipa,

Could you please share the sample data in a Excel file so that I can copy and paste? Also please post expected result based on the sample data you post.


Regards,
Lydia

[MK_Aqipa]

@v-yuezhe-msft

Hi Lydia,

here the link to the excel file with the two tabs (currency rates + sales). Data Example

the column "waers" in the Sales tab is always in local currency. Based on the respective period + rate, I would like to select with the slicer the sales (column "ums")  converted to the different currencies. In addition if possible I would like also other columns (f.e. umsp) converted with the same currency slicer. 

many thanks & regards

[v-yuezhe-msft]

@MK_Aqipa,

I am unable to access the data you shared as it requires permission.

Regards,
Lydia

[MK_Aqipa]

@v-yuezhe-msft

would you have another idea how to share excel files here in the community?

[v-yuezhe-msft]

@MK_Aqipa，

You can share the file via OneDrive or dropbox, make sure the file you share doesn't require access.

Regards,
Lydia

[MK_Aqipa]

@v-yuezhe-msft

hope it's working now...here is the link: Dropbox Link

Thanks & BR

[MK_Aqipa]

@v-yuezhe-msft

Hi Lydia,

was the download of the data possible? If yes, did you have any luck to look into the data?

Thanks a lot,

BR

[v-yuezhe-msft]

@MK_Aqipa,

Please check if the DAX in the PBIX file below returns your expected result.

Regards,
Lydia