Filtering Measure by a Calculated Dimension

[luisccmm]

I have created this calculated dimension.

Aggr(count(distinct Supplier),Product)

The result of the above is the number of suppliers that offer one product. For example, Product 1 is offered by 5 suppliers.

I need now to calculate the following.

% of total products offered by supplier that are only offered by only 1 supplier.

The expected result is a bar chart where...

Supplier 1      50% of the products Supplier 1 offers are only offered by Supplier 1.

Supplier 2     40% of the products Supplier 2 offers are only offered by Supplier 2.

I have tried the following in a bar chart

Dimension

Supplier

Measure

=if(Aggr(count(distinct Supplier),Product)=1,

Count( distinct Product)/ count ( TOTAL<Supplier> distinct Product))

And the result of that is 

[sunny_talwar · Accepted solution]

How about this

Count(DISTINCT {<Product = {"=Count(DISTINCT Supplier) = 1"}>} Product)/
Count(DISTINCT Product)

[luisccmm]

Thanks Sunny, as fast as always!!