cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ovetteabejuela Established Member
Established Member

Measures (Data) > Exporting Underlying Data

asCan Measures be exported as underlying data? I noticed that they are absent upon Exporting as Underlying Data but yes they do appear when exported as a summary. However, we need it for underlying data.

4 REPLIES 4
Community Support Team
Community Support Team

Re: Measures (Data) > Exporting Underlying Data

Hi @ovetteabejuela 

It should be possible to export Measures as underlying data.

Please check the Export underlying data details.

If it can't slove your puzzles, please show an example what you happen to and what you need to export.

 

Best Regards

Maggie

Highlighted
ovetteabejuela Established Member
Established Member

Re: Measures (Data) > Exporting Underlying Data

Yes, according to that documentation, it should however I am not getting that..

 

The image below is the actual visual (sorry had to blur out) but basically it is:

- a matrix

- no rows, only columns(week starting) and the matrices as values(where it is a mix of column and measure)

 

Measures not Exporting.PNG

Community Support Team
Community Support Team

Re: Measures (Data) > Exporting Underlying Data

Hi @ovetteabejuela 

"the matrices as values(where it is a mix of column and measure)"

Could you show me how the column and measure mix?

 

As tested,

If you add a measure and a column in the "Value" field of the matrix,

After exporting underlying data, the measure and column can be exported.

 

If you create a measure by adding a column and a measure, 

then add this new measure in the "Value" field of the matrix,

After exporting underlying data, only the new measure can be exported.

 

If you create a column by adding a column and a measure, 

then add this new column in the "Value" field of the matrix,

After exporting underlying data, only the new column can be exported.

 

Please refer to my pbix to see more details.

 

If my assumption doesn't hit your scenario, please show me more details.

 

Best Regards

Maggie

 

 

 

Community Support Team
Community Support Team

Re: Measures (Data) > Exporting Underlying Data

Hi @ovetteabejuela 

It seems that there is some misconception in Summarized data/Underlying data for you.

Please read this thread to know differences of Summarized data/Underlying data.

 

Best Regards

Maggie

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 136 members 1,602 guests
Please welcome our newest community members: