Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Export Underlying Data

I have a matrix of a measure that I created, field1/field2, over time. However, when I try to export the underlying data, the field1 and field2 numbers are not correct. However, when I recreate the matrix with field1 and field2 as the values and export it, the numbers are correct. Why do measures in the value field export incorrect data?

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    Based on my test, I cannot reproduce your issue here. I created the measure as below.

     

    Measure = SUM(Table1[field1])/SUM(Table1[field2])

     

    Could you please share your pbix to me if possbile so that I can test again?

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support
      7 years ago

      Hi Anonymous,

       

      Has your issue been solved? If any other question, feel free to let me know please.

       

      Regards,

      Frank