Calculated dimension - Shows all fields of the dimension in Current Selection

[#1]

Hi,

With the usage of calculated dimension, we have encountered with the below issues:

-          - When a selection is made on the calculated dimension graph, all the values of the dimension gets applied on the current selection.

-          - The field that is used to calculate the dimension gets selected as well(this field if of an independent table)

Attached is the sample file(please see 2^nd graph) to illustrate this. could you please advise if we can overcome this with an alternate solution.