2 visual outcome but with only 1 relationship between tables.

[TcT85]

At the moment I have relationship between the columns Product.

I would like to get 2 report view visuals.

1 visual that has product in X axis that shows the quantity of each product produced. This works when I have relations ship with Product

2nd visual the XDate in X axis. when I try to display the qty per Month it will count the total qty for both months. I want to know the quantity per month.

How can I setup so that both these visuals work with only 1 relationship?

Product	XDate	QTY
Red Toy	2022-01-01	55
Red Toy	2022-01-02	11
Red Toy	2022-01-03	515
Red Toy	2022-01-04	513
Red Toy	2022-01-05	53
Red Toy	2022-01-06	13
Red Toy	2022-01-07	113
Red Toy	2022-01-08	113
Red Toy	2022-01-09	112
Red Toy	2022-01-10	113
Red Toy	2022-01-11	113
Blue Toy	2022-01-12	113
Green Toy	2022-01-13	114
Green Toy	2022-02-14	115
Green Toy	2022-02-15	116
Green Toy	2022-02-16	117
Green Toy	2022-02-17	118
Green Toy	2022-02-18	119
Green Toy	2022-02-19	120
Yellow Toy	2022-02-20	121
Purple Toy	2022-02-21	122
Black Toy	2022-02-22	123
White Toy	2022-02-23	124

Product	Serial number	Faulty	Date
Red Toy	1234	Defect	2022-01-01
Red Toy	1235	Defect	2022-01-01
Red Toy	1236	Defect	2022-01-01
Red Toy	1237	Defect	2022-01-01
Red Toy	1238	Defect	2022-01-01
Red Toy	1239	Defect	2022-01-01
Red Toy	1240	Defect	2022-01-01
Red Toy	1241	Defect	2022-01-10
Red Toy	1242	Defect	2022-01-10
Red Toy	1243	Defect	2022-01-10
Red Toy	1244	Defect	2022-01-11
Green Toy	1245	Defect	2022-02-16
Green Toy	1246	Defect	2022-02-17
Green Toy	1247	Defect	2022-02-18
Green Toy	1248	Defect	2022-02-19

[TcT85]

Hi @Anonymous 

Here is a image where it gets wrong on the visualisation on the bottom.

It count the totalt amount of defects but is a input for every day.

I need to get how many defects there was for each day.

[Anonymous · Accepted solution]

Hi @TcT85 ,

Sorry for late reply!
May I ask if this is the result you are looking for?

Here is the relationship:

And I create a measure:

Fauty = COUNT('Table (2)'[Faulty])

Put this measure into both visuals.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @TcT85 ,

I'm a bit confused because according to your description, the table below doesn't need to be used at all to accomplish the creation of your two visual objects, i.e., you don't need to use any relationships at all:

See the example I provided:

Even though you must have a relationship between your two tables, the relationship will not be used because both visual objects only need to use columns from one table.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.