Customized Table Visual

[Anonymous]

I have these sample tables 

Intake Table
Intake #	State	Request Type	Project Name
LNC-001	Active	Others	Protégé 201
LNC-002	Cancelled	Issue	Dimesion 56
LNC-003	Resolved	Problem	Monthly dispatch
LNC-004	Active	Review	Bend Joint
LNC-005	Active	Problem	Clive Bandwidth
LNC-006	Active	Review	Business Reengineering
LNC-007	Cancelled	Problem	Type Cde cleanup
LNC-008	Resolved	Review	Protégé 205
LNC-009	Active	Problem	Protégé 2024
LNC-010	Active	Review	Protégé 209
Property Table
Property #	Intake #	Property Address	Status
PL001	LNC-004	123 Fake street	Active
PL002	LNC-005	234 Vulture street	Resolved
PL003	LNC-004	67 glossy sw	Active
PL004	LNC-008	123 Fake street	Active
PL005	LNC-008	90 weint street	Active
Reviewing Table
Review ID	Intake #	Review Subject	Status
RW001	LNC-004	Test Ground	Active
RW002	LNC-005	Reflect Project	Active
RW003	LNC-004	Ultra freight	Active
RW004	LNC-008	Candles test	Active
RW005	LNC-008	Resting house	Active
RW006	LNC-010	design Ground	Active

Closing Table
Closing ID	Intake #	Closing Subject	Status
CL001	LNC-004	TESTING	Active
CL002	LNC-005	Muse	Active
CL003	LNC-004	Bottle	Active
CL004	LNC-008	Drinks	Active
CL005	LNC-008	Rest	Active
CL006	LNC-005	Yellow	Active

I want to achieve this. Thank you in advance

Intake #	State	Request Type	Project Name	# of Properties	# of Reviews	# of Closing
LNC-001	Active	Others	Protégé 201	0	0	0
LNC-002	Cancelled	Issue	Dimesion 56	0	0	0
LNC-003	Resolved	Problem	Monthly dispatch	0	0	0
LNC-004	Active	Review	Bend Joint	2	2	2
LNC-005	Active	Problem	Clive Bandwidth	1	1	2
LNC-006	Active	Review	Business Reengineering	0	0	0
LNC-007	Cancelled	Problem	Type Cde cleanup	0	0	0
LNC-008	Resolved	Review	Protégé 205	2	2	2
LNC-009	Active	Problem	Protégé 2024	0	0	0
LNC-010	Active	Review	Protégé 209	0	1	0

[Greg_Deckler · Accepted solution]

@Anonymous So like the attached PBIX file? (below signature)

[Anonymous]

Thank you. i see what you did. A count