I am attempting to create a Sankey chart to show the flow of people from education provider to placement provider to employer.
The below example contains Measure = Count (distinct [person]) and in this instance, this = 1.
However, because this 1 person went to 3 placement providers, it then means that there is a count of 3 in the education provider and employer, even though this should be = 1.
What am I doing wrong here?