In UI, given calculated dimension and selected filter as "No", result is showing all values

[Krishna_Kiran]

Hi All,

In UI while I am trying to give calculated dimension and selected filter as "No", result is showing all values

Table 1 :

If([Sub]='1' and [DOC] ='1','Yes', 'No') as [Product]

noconcatenate

Table 2 :

If([Text]='1' and [CHNL] ='0','Yes', 'No') as [Text]

In the UI while i am trying to give calculated dimension

=if([Text]='Yes' and [Product]='Yes','Yes',
if(([Text]='No' and [Product]='Yes') or ([Text]='No' and [Product])='No' ,'No'))

I can able to filter the values for Yes , But while trying to select No, It is selecting all.

Please help me, how to select "No" values.

Note: We have option to combine those two tables but, due to large volume of data i couldn't combine it.
I am trying to show as calculated dimension

Thanks,

Krishna