Oscar - your approach seems valid to me. I have recreated it on my end and I don't think you should have an issue with this. Use the calculation you created:
If [Job] = [Bit Selection]
I called it [Filtered Bit Depth]. Just drag this calculation onto your rows shelf to the right of [Hole_Depth]. Then right click your [Filtered Bit Depth] calculation on your rows shelf and select Dual Axis. Then use your parameter to filter the [Filtered Bit Depth], while [Hole_Depth] should remain unchanged and independent of your [Bit Selection] parameter.
Thanks Ben, certainly you are right, it works. However, the list of options in the parameter control is fixed and I have to change it manually instead of being tie to the filter related to the project I want to display Bit_Depth. I attached a sample where Job Comparison filters is selecting 5 jobs where 1731 is excluded. But the parameter list displays all the job.
The idea is to display many projects and just adding bit_depth for only one of them. So, one filters is selecting the projects to compare but I need a second filter just for one specific project. Also, I would like to used this second filter (for one specific project) in all the database. I think there is a conflict because both filters are pointing the same field "Project".
Bit Selection.twbx 1.4 MB
I am still fighting with this issue. Checking the forum I couldn't find any helpful information. I attached another file easier to understand the situation. In the first "Jobs to Compare" sheet I have two filters selecting the "Client" (global filter) and "Jobs to Compare" (global filter), also a static parameters (function I am using temporally to show the bit_depth). And in the second sheet "Job to Analyse" I have one filter "Job to Analyze". Now, what I want to do? display bit_depth measure for a specific job that is selected in "Job to Analyse" filter.
The problem is, as soon as I include the "Job to Analyse" filter in "Jobs to Compare" sheet, it will exclude all the jobs I want to compare.
One solution that I have is using "Parameter", BUT the selection is static and also it brings all the job that I have in my database (I only want to display the jobs that have been selected in "Jobs to Compare" filter). The ideal solution would be referring the filter status into the calculated field. Is it possible? how can I display the Bit_Depth related only to "Job to Analyse" in my "Jobs to Compare" chart?
Bit Selection.twbx 1.3 MB
I wanted to follow up on this request as a member of our training team mentioned that you had reviewed this issue with her awhile back and it did not appear as answered here.
Parameters are static as you identified. Jonathan Drummey provided one potential workaround on the his web site here: Creating a Dynamic “Parameter” with a Tableau Data Blend | Drawing with Numbers
In addition, I suggest adding your voice and vote to the Feature Request identified here: http://community.tableau.com/ideas/1178
I hope this helps.
Thanks Patrick... I voted already