I am trying to do a calculation using the below queries.

[Anonymous]

Potential # of Payouts = CALCULATE(COUNTA('Table1'[Incentive Pool]), ALLSELECTED('Table1'[Incentive Pool]))*0.20.  This = 462

I want to multiply the results from the ( Potential # of Payouts) by $700. The correct answer is $323,400.

Using this query: Potential Payout Amount = [Potential # of Payouts]*700. I get $323,540. ($140.00 more than the correct amount)

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Maybe [Potential # of Payouts] is in the format of Whole Number. The real number of [Potential # of Payouts] is 462.2?

$323,400 = 462 * $700

$323,540 = 462.2 * $700

If you need $323,400 , please try:

Potential Payout Amount = ROUND([Potential # of Payouts],0)*700

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks, it worked!

[amitchandak]

@Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try like

Sumx('Table1', [Potential # of Payouts]*700)

[Anonymous]

Solution was provided by v-jianboli-msft.

[Anonymous]

This is some of the sample date uising the Sumx. I am getting pretty much the same results. Some of the caculations for "Potential Number of Payouts" are correct but most are not.

Service Line	Incentive Pool	Number of payouts	Number of Potential Payouts	Payout Totals	Potential Payouts Amount
Capital Projects	CIP001CP	12	14	$8,400	$9,800
Capital Projects	CIP003CP	0	3	$0	$2,100
Capital Projects	CIP004CP	2	3	$1,400	$2,100
Capital Projects	CIP005CP	0	1	$0	$560
Capital Projects	CIP006CP	0	1	$0	$840
Capital Projects	CIP007CP	3	3	$2,100	$2,240
Capital Projects	CIP008CP	1	1	$700	$840
Capital Projects	CIP009CP	2	2	$1,400	$1,680
Capital Projects	CIP010CP	1	1	$700	$840
Capital Projects	CIP011CP	1	1	$700	$980
Capital Projects	CIP012CP	2	3	$1,400	$1,820
Capital Projects	CIP013CP	1	2	$700	$1,120
Capital Projects	CIP014CP	0	0	$0	$280
Customer Account Services	CAS001BS	6	7	$4,200	$4,900
Customer Account Services	CAS001CO	2	3	$1,400	$1,820
Customer Account Services	CAS001IC	2	2	$1,400	$1,540
Customer Account Services	CAS001MR	8	9	$5,600	$6,440
Customer Account Services	CAS001MS	3	4	$2,100	$2,660
Customer Account Services	CAS001SS	1	1	$700	$700
Customer Account Services	CAS002BS	0	1	$0	$980
Customer Account Services	CAS002CO	1	1	$700	$840
Customer Account Services	CAS002IC	1	2	$700	$1,400
Customer Account Services	CAS002MR	1	2	$700	$1,260
Customer Account Services	CAS002MS	2	3	$1,400	$1,820
Customer Account Services	CAS002SS	0	1	$0	$840
Customer Account Services	CAS003BS	0	1	$0	$560
Customer Account Services	CAS003CO	4	8	$2,800	$5,600
Customer Account Services	CAS003MS	0	2	$0	$1,120
Customer Account Services	CAS004BS	1	2	$700	$1,120
Customer Account Services	CAS004CC	0	1	$0	$420
Customer Account Services	CAS004CO	0	1	$0	$980
Customer Account Services	CAS005BS	1	1	$700	$840
Customer Account Services	CAS005CC	1	1	$700	$840
Customer Account Services	CAS006BS	1	2	$700	$1,260

[Anonymous]

Solution was provided by v-jianboli-msft. Thanks!