Dynamic Meassure Selection

Hey,

give this a try:

Total Sales by Dept = IF (ISCROSSFILTERED(DynamicSelection[Selection]) ,
SWITCH(TRUE(),
VALUES(DynamicSelection[Selection]) = "Finance" , CALCULATE(SUM('TableDept'[Total Cost(USD)])),
VALUES(DynamicSelection[Selection]) = "Account" , 'TableDept'[Total Cost (EUR)],
VALUES(DynamicSelection[Selection]) = "Operations" , 'TableDept'[Total Cost (Fr)],
BLANK()))

I just changed one column reference :-), put the CALCULATE(SUM(...)) around the remaining column references.

If this will not solve your issue, you might consider to prepare a pbix file with some sample data, upload the file to onedrive or dropbox and share the link.

Regards,

Tom