Hello,Please can you help me in adding target to the matrix. I tried to add a measure as Target =2 and it works for individual records but it does not sum and in the total it shows as 2 rather than summarized. Not sure how else to add this target. My raw data asTMRDOrdIDOrdStatusOrdStatusDateRegionJohn SmithSteve TannerABC123Entered1/1/2022WestJohn SmithSteve TannerABC123Shipped1/5/2022WestJohn SmithSteve TannerABC123Complete2/10/2022WestJohn SmithSteve TannerABC234Entered1/1/2022WestJohn SmithSteve TannerABC234Shipped1/10/2022WestJohn SmithSteve TannerABC234Complete1/15/2022WestJohn SmithSteve TannerABC345Entered2/5/2022NWJohn SmithSteve TannerABC345Shipped2/7/2022NWJohn SmithSteve TannerABC345Complete2/10/2022NWMary JaneBridget FDEF123Entered2/5/2022EastMary JaneBridget FDEF123Shipped2/5/2022EastMary JaneBridget FDEF123Complete2/5/2022EastBrad MarleyJohn QEFG123Entered2/16/2022EastBrad MarleyJohn QEFG123Entered2/16/2022EastBrad MarleyJohn QEFG123Entered2/16/2022EastBrad MarleyJohn QEFG234Entered2/16/2022WestBrad MarleyJohn QEFG234Entered2/16/2022WestBrad MarleyJohn QEFG234Entered2/16/2022West Expected to have two outputs. When adding region, though John Smith shows up twice, he still has a target of 2 per region and when region is not displayed, he is still supposed to have 2 as the target. And the totals should sum up correctly. Output 1: TMRegionComplete CountComplete Target John SmithWest22 Mary JaneEast12 John SmithNW12 Brad MarleyEast12 Brad MarleyWest12Total 610 Output 2: TMComplete CountComplete Target John Smith32 Mary Jane12 Brad Marley22Total 66

Hi, maybe I misunderstand you, please try this one complete_target = var target = 2 return SUMX(SUMMARIZE(datatable,TM column),target)

PBI5851

Helper V

4 years ago

Solved

Adding Targets to Matrix

Hello,

Please can you help me in adding target to the matrix. I tried to add a measure as Target =2 and it works for individual records but it does not sum and in the total it shows as 2 rather than summarized. Not sure how else to add this target.

My raw data as

TM	RD	OrdID	OrdStatus	OrdStatusDate	Region
John Smith	Steve Tanner	ABC123	Entered	1/1/2022	West
John Smith	Steve Tanner	ABC123	Shipped	1/5/2022	West
John Smith	Steve Tanner	ABC123	Complete	2/10/2022	West
John Smith	Steve Tanner	ABC234	Entered	1/1/2022	West
John Smith	Steve Tanner	ABC234	Shipped	1/10/2022	West
John Smith	Steve Tanner	ABC234	Complete	1/15/2022	West
John Smith	Steve Tanner	ABC345	Entered	2/5/2022	NW
John Smith	Steve Tanner	ABC345	Shipped	2/7/2022	NW
John Smith	Steve Tanner	ABC345	Complete	2/10/2022	NW
Mary Jane	Bridget F	DEF123	Entered	2/5/2022	East
Mary Jane	Bridget F	DEF123	Shipped	2/5/2022	East
Mary Jane	Bridget F	DEF123	Complete	2/5/2022	East
Brad Marley	John Q	EFG123	Entered	2/16/2022	East
Brad Marley	John Q	EFG123	Entered	2/16/2022	East
Brad Marley	John Q	EFG123	Entered	2/16/2022	East
Brad Marley	John Q	EFG234	Entered	2/16/2022	West
Brad Marley	John Q	EFG234	Entered	2/16/2022	West
Brad Marley	John Q	EFG234	Entered	2/16/2022	West

Expected to have two outputs. When adding region, though John Smith shows up twice, he still has a target of 2 per region and when region is not displayed, he is still supposed to have 2 as the target. And the totals should sum up correctly.

Output 1:

	TM	Region	Complete Count	Complete Target
	John Smith	West	2	2
	Mary Jane	East	1	2
	John Smith	NW	1	2
	Brad Marley	East	1	2
	Brad Marley	West	1	2
Total			6	10

Output 2:

	TM	Complete Count	Complete Target
	John Smith	3	2
	Mary Jane	1	2
	Brad Marley	2	2
Total		6	6

Need Help

HoangHugo
4 years ago
Hi, maybe I misunderstand you, please try this one

complete_target =
var target = 2
return SUMX(SUMMARIZE(datatable,TM column),target)

Forum Discussion

Adding Targets to Matrix

3 Replies

Related content

Adding target ROW into matrix

Matrix Adding total from previous Group

Adding columns

Adding a second subtotal in a matrix

Adding color to rows in Matrix