calculate measure to put in matrix

[snifer]

year	month	amount	code	company
2017	1	1000	101	dd
2017	2	3000	101	dd
2017	3	7000	101	dd
2017	4	10000	101	dd
2017	5	14000	101	dd
2017	6	18000	101	dd
2017	7	25000	101	dd
2017	8	30000	101	dd
2017	9	40000	101	dd
2017	10	75000	101	dd
2017	11	95000	101	dd
2017	12	100000	101	dd
2018	1	2000	101	dd
2018	2	3000	101	dd
2018	3	5000	101	dd
2018	4	7000	101	dd
2018	5	10000	101	dd
2018	6	12000	101	dd
2018	7	15000	101	dd
2018	8	19000	101	dd
2018	9	30000	101	dd
2018	10	40000	101	dd
2018	11	45000	101	dd
2018	12	50000	101	dd
2017	1	1000	102	dd
2017	2	3000	102	dd
2017	3	7000	102	dd
2017	4	10000	102	dd
2017	5	14000	102	dd
2017	6	18000	102	dd
2017	7	25000	102	dd
2017	8	30000	102	dd
2017	9	40000	102	dd
2017	10	75000	102	dd
2017	11	95000	102	dd
2017	12	100000	102	dd
2018	1	2000	102	dd
2018	2	3000	102	dd
2018	3	5000	102	dd
2018	4	7000	102	dd
2018	5	10000	102	dd
2018	6	12000	102	dd
2018	7	15000	102	dd
2018	8	19000	102	dd
2018	9	30000	102	dd
2018	10	40000	102	dd
2018	11	45000	102	dd
2018	12	50000	102	dd
2017	1	1000	101	hh
2017	2	3000	101	hh
2017	3	7000	101	hh
2017	4	10000	101	hh
2017	5	14000	101	hh
2017	6	18000	101	hh
2017	7	25000	101	hh
2017	8	30000	101	hh
2017	9	40000	101	hh
2017	10	75000	101	hh
2017	11	95000	101	hh
2017	12	100000	101	hh
2018	1	2000	101	hh
2018	2	3000	101	hh
2018	3	5000	101	hh
2018	4	7000	101	hh
2018	5	10000	101	hh
2018	6	12000	101	hh
2018	7	15000	101	hh
2018	8	19000	101	hh
2018	9	30000	101	hh
2018	10	40000	101	hh
2018	11	45000	101	hh
2018	12	50000	101	hh
2017	1	1000	102	hh
2017	2	3000	102	hh
2017	3	7000	102	hh
2017	4	10000	102	hh
2017	5	14000	102	hh
2017	6	18000	102	hh
2017	7	25000	102	hh
2017	8	30000	102	hh
2017	9	40000	102	hh
2017	10	75000	102	hh
2017	11	95000	102	hh
2017	12	100000	102	hh
2018	1	2000	102	hh
2018	2	3000	102	hh
2018	3	5000	102	hh
2018	4	7000	102	hh
2018	5	10000	102	hh
2018	6	12000	102	hh
2018	7	15000	102	hh
2018	8	19000	102	hh
2018	9	30000	102	hh
2018	10	40000	102	hh
2018	11	45000	102	hh
2018	12	50000	102	hh

This is may data in the table

i need to make a measure that will calculate>

for month 1 year "2018" the company "dd" the sum of the "amount" for the code "101" and "102"

keep in mind that i need the month and year and company to be dynamic, meaning that these gonna chnage based on month and yar and company I do need to calculate at moment.

example result= amount( code101 for month x and year xcompany z)+amount(code 102 for month x and year xcompanz)-> same month and year fand company for both code

month and year  companywill be filtered in powerbi dashboard

i want to buil a matric where column will be onth of the year and it will be selecting year and company

															company selector		year
															hh			2018
	1	2	3	4	5	6	7	8	9	10	11	12
sum calculated both code

[v-frfei-msft]

Hi @snifer,

---

example result= amount( code101 for month x and year xcompany z)+amount(code 102 for month x and year xcompanz)-> same month and year fand company for both code

---

Sorry I cannot get you. What is your excepted reuslt then? 

Regards,

Frank

---