XIRR aggregration on some groups but not other

[GAPER]

Here is my table.

You see the first groupping of 11.9% is a right IRR (using all the cash flows from the 2 projects underthese 2 groups)

however when it comes to the second one, it's not giving me the right number, despite each individual project irr is correctly calculated. 

Anyone knows how to fix this? Thanks

I have created a dummmy cashflow to replicate the above

Industry	Project	CF_DATE_DUMMY	Total Value
1	a	1/1/2004	-50
1	a	7/1/2004	135
2	b	12/18/2007	-10
2	b	12/31/2007	-380
2	b	3/4/2008	-10
2	b	8/31/2008	-240
2	b	11/30/2008	-5
2	b	12/21/2010	15
2	b	4/4/2011	5
2	b	4/30/2011	10
2	b	7/14/2011	140
2	b	1/31/2012	-115
2	b	2/28/2012	115
2	b	3/31/2012	-95
2	b	4/30/2012	115
2	b	5/14/2012	10
2	b	8/31/2012	5
2	b	10/5/2012	-15
2	b	2/28/2013	-5
2	b	3/31/2013	80
2	b	4/10/2013	80
2	b	5/31/2013	5
2	b	7/31/2013	-15
2	b	1/31/2014	-90
2	b	6/30/2014	5
2	f	3/16/2015	-10
2	f	7/22/2015	-5
2	f	8/10/2015	-5
2	f	3/30/2017	40
2	f	5/19/2017	40
2	f	5/31/2017	-10
2	f	8/31/2017	100
2	f	9/28/2017	-175
2	f	10/31/2017	25
2	f	11/13/2017	-25
2	f	4/9/2018	50
2	f	4/10/2018	5
1	l	7/28/2017	-10
1	l	8/3/2018	12
1	m	12/18/2017	-10
1	m	8/3/2018	10
1	m	8/9/2018	1

[Fowmy]

@GAPER 

You need to share some sample/dummy data and the measure you have used.
Better, if you can share a PBIX file 

[GAPER · Accepted solution]

Updated King. Please help