Adding Targets to Matrix

[PBI5851]

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

[PBI5851]

@HoangHugo It is not working as it is summing up every single occurence. 

[HoangHugo · Accepted solution]

Hi, maybe I misunderstand you, please try this one

complete_target =

  var target = 2

  return SUMX(SUMMARIZE(datatable,TM column),target)

[HoangHugo]

Hi,

try this one

measure

complete_target =

  var target = 2

  return SUMX(datatable,target)