Set Analysis - And & Excluded

[mulan1]

I am doing project for school, in which I am trying to do a Scatter Plot chart to compare Campaigns. The comparison is between campaigns that were in both 2019 *and* 2020 by sales. I also want to remove the 'No Campaign' campaign.
I am having trouble with AND logic. Also, the sales of 'No Campaign' have been reset (they were not 0) and it is still in the chart.

I tried something like:
X-Axis Measure :
Sum({<CampaignName = P({<Year={2019}>} CampaignName) * P({<Year={2020}>}  CampaignName) - {'No Campaign'},Year={2020}>} LineSalesAmount)

Y-Axis Measure:
Sum({<CampaignName = P({<Year={2019}>} CampaignName) * P({<Year={2020}>}  CampaignName) - {'No Campaign'},Year={2019}>} LineSalesAmount)

not shure about it.

Thanks in advance for the help.

[Kushal_Chawda]

@mulan1  I think below measures should work

X-Axis Measure:
Sum({<CampaignName-={'No Campaign'},Year={2019}>} LineSalesAmount)

Y-Axis Measure:
Sum({<CampaignName-={'No Campaign'},Year={2020}>} LineSalesAmount)

[mulan1]

Thanks for the quick response, but unfortunately this solution doesn't work. I only want to compare campaigns that run in both 2020 *and* 2019, and here I see campaigns that run in either 2020 *or* 2019. Also, 'No Campaign' resets again and is still inside the chart.