facing error in problem

[Anonymous]

Select Conversion=IF(ISBLANK(CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))),0,CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))))

[amitchandak · Accepted solution]

Try like

 Select Conversion=IF(ISBLANK(CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))))),0,CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer)))))

[v-yiruan-msft · Accepted solution]

Hi @San1979 ，

Three right parenthesis were missing in your formula, please see the red mark in the formula below:

Select Conversion=IF(ISBLANK(CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))) )) ,
0,
CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer)))) )

In addition, your formula looks a bit messy. In fact, you can organize your formula with the help of DAX formatting tool. And if the formula has any error, it will be easier and faster to find the cause after formatted.

Best Regards

Rena

[v-yiruan-msft]

Hi @Anonymous ，

Three right parenthesis were missing in your formula, please see the red mark in the formula below:

Select Conversion=IF(ISBLANK(CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))) )) ,
0,
CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer)))) ）

In addition, your formula looks a bit messy. In fact, you can organize your formula with the help of DAX formatting tool. And if the formula has any error, it will be easier and faster to find the cause after formatted.

Best Regards

Rena

[Greg_Deckler]

Yeah, that code is a mess. Always format your code properly to avoid this kind of thing. This is what I think you were going for:

Select Conversion=
	IF(
		ISBLANK(
			CALCULATE(
				DIVIDE(
					COUNTX(
						FILTER(
							'CUSTOMER Lookup',
							[Type]="MEMBER"
						),
						[CUSTid]
					),
					CALCULATE([CUSTid],all(Customer))
				)
			)
		),
		0,  //True statement
		CALCULATE(
			DIVIDE(
				COUNTX(
					FILTER(
						'CUSTOMER Lookup',
						[Type]="MEMBER"
					),
					[CUSTid]
				),
				CALCULATE([CUSTid],all(Customer))
			)
		)  //False statement
	)
	

[Greg_Deckler]

Also, here is a much, much better way to write that code:

Select Conversion=
	VAR __Calculation = 
		CALCULATE(
			DIVIDE(
				COUNTX(
					FILTER(
						'CUSTOMER Lookup',
						[Type]="MEMBER"
					),
					[CUSTid]
				),
				CALCULATE([CUSTid],all(Customer))
			)
		)
RETURN
	IF(ISBLANK(__Calculation),0,__Calculation)

[amitchandak · Accepted solution]

Try like

 Select Conversion=IF(ISBLANK(CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer))))),0,CALCULATE(DIVIDE(COUNTX(FILTER('CUSTOMER Lookup',[Type]="MEMBER"),[CUSTid])
,CALCULATE([CUSTid],all(Customer)))))