Issues when using join concept in data modeling

[Hussaina1]

Attached File Description: Both the files contains the same mock data only difference is in implementation

1. Using Join.qvw file: Consists of data where join is applied between the tables

2. Using concatenate.qvw file: Consists of data where concatenate is applied between the tables

Requirement:

1. We want to perform crosstable on two different columns in the data (as shown in attachment)

2. Since we are dealing with huge amount of data we need to perform join instead of concat in our original dashboards

Issues:

1. We are getting cross product after using cross table in join data modeling.

2. Hence need to obtain results similar to concat but instead using join concept

Thank you.