2

I want to use the measures fields in both rows and columns in the MDX query and I have used the below query

SELECT{[Measures].[Average Rate]} ON COLUMNS, 
NONEMPTY(
  (
    TOPCOUNT(
      (
        Order(
          (
            ([Measures].[End of Day Rate])
          ), 
          [Measures].[Average Rate], 
          ASC
        )
      ), 
      201
    )
  ), 
  {[Measures].[End of Day Rate]}
) ON ROWS 
FROM 
  [Adventure Works] CELL PROPERTIES VALUE, 
  FORMATTED_VALUE, 
  FORMAT_STRING


but when am using getting the below error.

The Measures hierarchy already appears in the Axis0 axis.

Please share the steps to resolve the error.

Venkat
  • 2,549
  • 2
  • 28
  • 61
TAMILARASAN R
  • 225
  • 1
  • 6

0 Answers0