Matrix Visual: Count of column showing inaccurate results

[AJV]

Hello,

I'm having a problem creating a somewhat simple table to show participation results for a survey.

You'll notice that the second column does not add up to the total at the bottom. When I look at the data, the number is correct in the table, but not in the visual.

I have two different data sources - one is the invitation list that shows all possible respondents and their associated demographic data (Called MASTER DATA) and one of the responses recieved (Results).

The counts seem to be fine coming in from the Results data, but not from the MASTER DATA table, despite the info in the table being correct.

Here's the settings for the visual:

I'm just looking for a simple count, so the third column can calculate properly.

Any ideas?

[Anonymous]

@AJV 

This seems caused by the many to many relationship, where invitation could could count multiple times. Try create a bridge table with Distinct(table[Invitation number]). Then create 1:many relationship between the new table and 2 original table. 

Paul Zheng _ Community Support Team

If this post helps, please Accept it as the solution to help the other members find it more quickly.