Add total groups from Table 1 as new column to Table 2

[bidata]

Hello,

I am trying to add a new column into Table2 as I show below in DAX:

Table1
ofice	group	status	value
a	d	z	1
a	d	y	0
a	f	z	2
a	f	y	2
b	g	z	0
b	g	y	2
b	h	z	1
b	h	y	1
a	d	z	0
a	d	y	1
a	f	z	4
a	f	y	1
b	g	z	3
b	g	y	3
b	h	z	1
b	h	y	5

Table2
DATE	ofice	group	value
01/01/2022	a	d	1	1+0
01/01/2022	a	f	4	2+2
01/01/2022	b	g	2	0+2
01/01/2022	b	h	2	1+1
02/01/2022	a	d	1	0+1
02/01/2022	a	f	5	4+1
02/01/2022	b	g	6	3+3
02/01/2022	b	h	6	1+5

And then i need to be able to filter by multiple items by Status from table1.

Thank you in advance! 

[v-chenwuz-msft · Accepted solution]

Hi @bidata ,

A little confused, is that Table2 a visualiztion?

If yes, just need to put the value from Table1 into the table visual.

Pbix in the end you can refer.

If Table2 is a fact table, you can not change the total value by filter the status from Table1.

Best Regards

Community Support Team _ chenwu zhu

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