Calculate with multiple filters.

Question

I need to calculate the operating cost, lets say codes 900, 901 and 907, i am wondering if there is a way that i can only reference the table and column once and input all the code that i need istead of doing one by one like this example below and ading at the end:CALCULATE(SUM(Sheet1[Value]), Sheet1[Codigo]=900)then CALCULATE(SUM(Sheet1[Value]), Sheet1[Codigo]=901)then&nbsp;CALCULATE(SUM(Sheet1[Value]), Sheet1[Codigo]=907)...or even, Total cost = CALCULATE(SUM(Sheet1[Value]), Sheet1[Codigo]=900,Sheet1[Codigo]=901,Sheet1[Codigo]=907)&nbsp;Pardon the ignorance and much apreciated for the help.&nbsp;&nbsp;DescriçãoCodigoDescrição&nbsp;Conta RedusidaContontábilDescriçãoValue900 TTL Property Cost900900 TTL Custo da Propriedade+.9.4903.3.5.01.02Rent and occupational rate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 54.585,89900 TTL Property Cost900900 TTL Custo da Propriedade+.9.9703.4.1.05.50Rental and condominium fee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13.595,11900 TTL Property Cost900900 TTL Custo da Propriedade+.10.3303.4.1.05.17Maintenance and building repairs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 757,31900 TTL Property Cost900900 TTL Custo da Propriedade+.54.8703.4.1.05.60Aluguel e Taxa Condominial - IFRS 16-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34.032,83900 TTL Property Cost900900 TTL Custo da Propriedade..900TTL Property Cost&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34.905,47901 TTL Insurance &amp; Damages901901 TTL Seguros e Danos+.9.2103.3.2.01.05Insurance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.551,68901 TTL Insurance &amp; Damages901901 TTL Seguros e Danos+.10.0803.4.1.05.68Insurance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 395,58901 TTL Insurance &amp; Damages901901 TTL Seguros e Danos..901TTL Insurance &amp; Damages&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14.947,25907 TTL Licenses/Permits907907 TTL Licenças/Permissões+.10.3003.4.1.05.14Taxes and fees&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.127,13907 TTL Licenses/Permits907907 TTL Licenças/Permissões+.10.5003.4.1.05.72IPTU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.684,66907 TTL Licenses/Permits907907 TTL Licenças/Permissões+.10.5303.4.1.05.75Municipal and state fees&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.723,43907 TTL Licenses/Permits907907 TTL Licenças/Permissões..907TTL Licenses/Permits&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12.535,22922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.9.1703.3.2.01.01Fuel and lubricants&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 225,66922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.9.2003.3.2.01.04Parts and replacements&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.873,21922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.9.4503.3.4.01.03third-party services-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13.007,83922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.9.9903.4.1.05.52Maintenance and repairs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 143,18922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.10.1903.4.1.05.03Fuels and lubricants&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.133,81922 Basic Salaries and Holiday922922 Salários Básicos e Férias+.10.3403.4.1.05.18Auxiliary materials and consumables&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4.683,34

anonymous · Accepted Answer

Hi&nbsp;khhank10&nbsp;,
You can create a measure as below to get it, please find the details in the attachment.
Measure = CALCULATE ( SUM ( Sheet1[Value] ), Sheet1[Codigo] IN { 900, 901, 907 } )

Best Regards

Forum Discussion

Calculate with multiple filters.

1 Reply

Related content

CALCULATE with multiple filters

Calculating with Filters

Calculate Filters

Calculate and filter using multiple tables

Multiple Years Filter

Descrição	Codigo	Descrição		Conta Redusida	Contontábil	Descrição	Value
900 TTL Property Cost	900	900 TTL Custo da Propriedade	+	.9.490	3.3.5.01.02	Rent and occupational rate	54.585,89
900 TTL Property Cost	900	900 TTL Custo da Propriedade	+	.9.970	3.4.1.05.50	Rental and condominium fee	13.595,11
900 TTL Property Cost	900	900 TTL Custo da Propriedade	+	.10.330	3.4.1.05.17	Maintenance and building repairs	757,31
900 TTL Property Cost	900	900 TTL Custo da Propriedade	+	.54.870	3.4.1.05.60	Aluguel e Taxa Condominial - IFRS 16	- 34.032,83
900 TTL Property Cost	900	900 TTL Custo da Propriedade	..900	TTL Property Cost			34.905,47
901 TTL Insurance & Damages	901	901 TTL Seguros e Danos	+	.9.210	3.3.2.01.05	Insurance	14.551,68
901 TTL Insurance & Damages	901	901 TTL Seguros e Danos	+	.10.080	3.4.1.05.68	Insurance	395,58
901 TTL Insurance & Damages	901	901 TTL Seguros e Danos	..901	TTL Insurance & Damages			14.947,25
907 TTL Licenses/Permits	907	907 TTL Licenças/Permissões	+	.10.300	3.4.1.05.14	Taxes and fees	2.127,13
907 TTL Licenses/Permits	907	907 TTL Licenças/Permissões	+	.10.500	3.4.1.05.72	IPTU	8.684,66
907 TTL Licenses/Permits	907	907 TTL Licenças/Permissões	+	.10.530	3.4.1.05.75	Municipal and state fees	1.723,43
907 TTL Licenses/Permits	907	907 TTL Licenças/Permissões	..907	TTL Licenses/Permits			12.535,22
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.9.170	3.3.2.01.01	Fuel and lubricants	225,66
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.9.200	3.3.2.01.04	Parts and replacements	4.873,21
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.9.450	3.3.4.01.03	third-party services	- 13.007,83
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.9.990	3.4.1.05.52	Maintenance and repairs	143,18
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.10.190	3.4.1.05.03	Fuels and lubricants	1.133,81
922 Basic Salaries and Holiday	922	922 Salários Básicos e Férias	+	.10.340	3.4.1.05.18	Auxiliary materials and consumables	4.683,34