% of Distinct By Dimension

[SI_NY02]

I have a  pivot chart that looks like this where the measure is the UNIQUE customer ID

Sign Up Year	Last purch 1m	Last purch 2-3m	Last purch 4-6m	Last purch 7-12m
2016	73	102	101	133	409
2017	116	188	185	230	719
2018	98	170	207	277	752

I want to convert this to % customers by sign up year instead so it should return:

Sign Up Year	Last purch 1m	Last purch 2-3m	Last purch 4-6m	Last purch 7-12m
2016	17.8%	24.9%	24.7%	32.6%	100%
2017	16.1%	26.1%	25.8%	32.0%	100%
2018	13.0%	22.6%	27.5%	36.8%	100%

I've tried the statements below and neither work..

count(distinct [CustomerID])/Count({<[sign up year]>} Total distinct  [CustomerID])

count(distinct [CustomerID])/aggr (Count (distinct[CustomerID], [sign up year])

 Any suggestions would be appreciated!

[marcus_sommer · Accepted solution]

Try it in this way:

count(distinct [CustomerID]) / Count(Total <[sign up year]> distinct  [CustomerID])

- Marcus

[SI_NY02]

Thank you SOOO much!