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

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.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 115 members 1,802 guests
Please welcome our newest community members: