Best Answer · By JanBask Tableau Expert
Asutosh Jha JanBask Expert
Answered on Nov 19, 2019
Parameter works for a particular worksheet. If you have two different data sources in a workbook and based upon the different data sources you have created different worksheets then you might need to combine them in the dashboard. but as you mentioned you are using a calculated field in the filter and so your work will be a little easier. I would recommend you to use the parameter in the calculated field itself and not separately. this way you can achieve your desired result. you can write the code something like below-
Data Source 1:
If [FAC]=[Facility] then sum([Number of Records]) end
Data Source 2:
If [FAC2]=[Facility] then sum(Number of Records]) end