Calculated dimension in chart and total

[elrelrelr]

I have a stacked bar chart where the columns are split by a calculated dimension. What I want to have is a stacked barchart with all bars showing the percentages (i.e. summing to 1)

DIMENSIONS

Dim 1 year
Dim 2 =aggr({$*BM01} count(distinct [case_id]),  [person_id], [year] )

EXPRESSIONS

No of unique persons 
=count(distinct {$*BM01} [person_id])
Total for each year
=count( total <[year]> distinct  {$*BM01}  [person_id])

However, the two expressions just gives me the same numbers, and I have also tried with the <person id> after the total. Any other suggestions for how to achieve what I wanted?

So far, the best solution I have tried is a Mekko-chart, however, I am still not able to find out how to get labels with dim 2's share of each column.

Moving the calculation to the script is not an option.

[sunny_talwar · Accepted solution]

Not entirely sure, but does this help

=Aggr(NODISTINCT Count(DISTINCT {$*BM01}  [person_id]), year)

[elrelrelr]

Great, that was exactly what i needed 🙂

(Now i just need to understand why that worked)