Set Analysis - Uniques

[karolbags]

I have a set analysis formula counting Sales from “Germany” as follows:

(Count({<[Country]={‘Germany}>} Sales))

I would like to however only consider the uniques of a third column called “Submissions”. The current selection double counts Submissions.

How might I go about removing all duplicates of a third column / submissions column?

TIA!

[Vegar]

What if you start counting unique Submissions instead? Like this:

Count({<[Country]={'Germany'}>} distinct Submissions)

[BrunPierre]

Hi, From what I understand, perhaps this?

Count(DISTINCT If(Country='Germany' and Aggr(Count(DISTINCT Submissions),Country)=1,Sales,Null()))