Help with Syntax Error

[Milo17]

Hi, 

I am trying to create a new measure using a simple dax calculation-

Bounce % = DIVIDE(Pages[Bounces],Pages[Sessions])

But am getting the following message:

'The syntax for Pages is incorrect.......'

I have already used this formula to create the same measure in a different table, as below- 

Bounce Rate % = DIVIDE(Landing[Bounces],Landing[Sessions])

And it works fine. 

Can someone please shed some light? 

Thanks, 

A Struggling Newbie

[JDLee23]

Hi,

Looks like it should work! Can you post some screenshots / examples?

[Milo17]

 

I'm not sure that this will help, but I've been wrong before! 

Thanks!

[JDLee23]

Not sure if it's really this simple, but put ' ' round the table name Pages - e.g.

Bounce % = DIVIDE( 'Pages'[Bounces], 'Pages'[Sessions] )

[Milo17]

unfortunately not. 

....if you can read that!

[JDLee23]

Ah, right, sorry - the discrepancy arises because this is a measure, rather than a calculated column. In the previous instance you used the DIVIDE function, it was for a calculated column, not a measure.

Are you wanting this to be a measure or a calculated column?

[Milo17]

Ahhh! Got it! 

As it works as the calculated column, then that is what I will go with- hopefully this one will work too!

Thanks a lot. 🙂

[v-sihou-msft · Accepted solution]

@Milo17

To use a measure, you need to aggregate the columns in your formula like:

Bounce % = DIVIDE( SUM('Pages'[Bounces]), SUM('Pages'[Sessions]) )

For better understanding calculated column and measure, please refer to article below:

Calculated Columns and Measures in DAX

Regards,