Forum Discussion

Milo17's avatar
Milo17
Frequent Visitor
8 years ago
Solved

Help with Syntax Error

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 ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    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,

     

     

JDLee23's avatar
JDLee23
Helper I
8 years ago

Hi,

 

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

 

Milo17's avatar
Milo17
Frequent Visitor
8 years ago

 

 

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

 

Thanks!

  • JDLee23's avatar
    JDLee23
    Helper I
    8 years ago

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

     

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

    • Milo17's avatar
      Milo17
      Frequent Visitor
      8 years ago

      unfortunately not. 

       

       

      ....if you can read that!

      • JDLee23's avatar
        JDLee23
        Helper I
        8 years ago

        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?