Sum data by the dates if another colums incude specific text

[akarca]

Hi, 

I want to sum all data if there is "2 Spinner" data on the date (except 2 spinner data).

For example, on 01.01.2022 there is "2 spinners" item in the Item column. So, I would like to sum up only the other data (stop +breakdown + production) on Jan. 01.

Date	Data	Item
1.01.2022	20	2 Spinner
1.01.2022	50	stop
1.01.2022	45	Production
1.01.2022	480	breakdown
2.01.2022	122	breakdown
2.01.2022	65	2 Spinner
2.01.2022	46	Production
3.01.2022	89	stop
3.01.2022	48	breakdown
3.01.2022	50	stop
3.01.2022	60	Production
4.01.2022	45	Production
4.01.2022	60	stop
4.01.2022	92	breakdown
5.01.2022	74	2 Spinner
5.01.2022	45	Production
5.01.2022	10	stop

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[akarca]

Thank you so much. I tried. 

[Shreeram04 · Accepted solution]

Hi @akarca ,

Please find the below measure and screenshot for your reference.

Measure 6 = CALCULATE(SUM('Table (4)'[value]),FILTER('Table (4)','Table (4)'[pro]<>"2 spinner"))

Did I answer your question? Mark my post as a solution and also give KUDOS!

Thanks,

[akarca]

Firstly, thank you for your support. Actually, I solved the problem with a different formula. 

I wanted to sum data from dates containing 2 spinner texts.