Counting Unique values

[ZoeM]

Hi Community.

I have a unique situation in my dashboard which has me stomped:

I have data flowing in on an aggregated basis which populates one of the tabs i.e. YTD Sales = $XX. On another tab, I have a weekly view of this sales figure i.e. Week of 9/8/18 = $XX.

The issue is that when no week is selected, the YTD $XX is being doubled and in some cases tripled if that particular item has more than one weeks worth of data.

How can I distinguish the aggregate YTD data to show only the unique $XX and disregard other weekly values?

My aggregate expression is as follows:

=Count({<[Issue Category], [Issue Category]={'UnContained'},Reference_Only={'No'}>}  [Issue Category])

Any help provided will be greatly appreciated.