Forum Discussion
Help with Syntax Error
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,
Not sure if it's really this simple, but put ' ' round the table name Pages - e.g.
Bounce % = DIVIDE( 'Pages'[Bounces], 'Pages'[Sessions] )
unfortunately not.
....if you can read that!
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?
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. :)
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,