Forum Discussion

Rhea's avatar
Rhea
Frequent Visitor
6 years ago

Quick measure not exporting with Underlying data

Hi. I have a matrix table comparing spend vs volume per month. The Volume field is a quick measure, with a filter applied to it. 

 

When I export selecting underlying data, the Volume field does not appear in the Excel report. 

 

Is there a way to get the quick measure included in underlying data exports?

Need Help

6 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Rhea ,

    Please open the pbix file and check if you turn on the option that allow end users to export underlying data.

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Rhea's avatar
      Rhea
      Frequent Visitor
      6 years ago

      Thank you. 

       

      Yes this option has always been turned on.

       

      It's a bit frustrating as everything else exports except for the column that has the quick measure. I also can't do a basic filter as it will affect my other data on this table. 

       

      Would you be able to simulate exporting a report with Quick Measures and see if you get the same issue?

       

       

      Regards.

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Rhea ,

        Sorry for late back. Please check if you enable the option of "Export Data" in Tenant settings of Admin Portal.  And I create a sample to test it. It is working when the option is turned on. 

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.