Forum Discussion

Greenwoodr's avatar
Greenwoodr
Helper I
7 years ago
Solved

Exporting data created by measures

Hi,

 

I have a calculated measure, counting the number of active supporters, which works well and returns an answer  which is realistic but unfortunatly slightly different to the answer i get directly from SQL.

 

The Id of each of these individuals is available in the model but as there are 121k I cannt see which ones as the visulisations arent designed for this.

 

Is there a way to export the results of a calculated measure into a table so I can export out of BI and compair against my SQL derived list? 

 

Result:

MEasure

Active S =
  calculate 
       (
sum('Fact All Commitments'[Conversion (Committed Giving)]), filter('Commitment Codes','Commitment Codes'[Commitment Code]="S"
|| 'Commitment Codes'[Commitment Code]="S Corpemp"), filter(all('Fact All Commitments'),
'Fact All Commitments'[Startdate <=max('Date Dimension'[Current_month_end_Date])
&& ('Fact All Commitments'[ENDDATE]>max('Date Dimension'[Current_month_end_Date])
|| 'Fact All Commitments'[ENDDATE]=blank()))
)

 

  • Hi Greenwoodr ,

     

    You could publish the report to Power BI Service, then, export the summarized data in visual which is returned by measure to Excel.

     

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Greenwoodr ,

     

    You could publish the report to Power BI Service, then, export the summarized data in visual which is returned by measure to Excel.

     

    Best regards,

    Yuliana Gu