I saw that article.it was helpful.
I have one query.
I have 3 tables One main Table(A) and two sub tables(B and C).
In table A there is a unique column(CL1)
In table B and C CL1 is present but that is not unique.So basically a 1:N join is happening between table A to B and Table A to C.
There is no other composite key also present between these tables.
if I do some calculations like sum(<any measure in table A>).the value I am getting is more because number of rows have increased.
Is there any way I can do a sum(distinct <measure in tableA>).
I tried it.but it is not working.I am using Tableau public.
Is there any other ways to solve the issue?