Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Issue with "Underlying Data Export ".

Hello,   We have a table visual with few measures represented as columns.   While exporting the data from a table visual using "Underlying Data" feature, Power bI was not flatenning the exporte...
Need Help
sunnsonofindia's avatar
sunnsonofindia
Icon for Advocate II rankAdvocate II
3 years ago

Hey Anonymous & Others, Not sure whether you were able to resolve the issue, Eventhough it is too late now, posting the solution, so that it can help others.

 

I referred the sample file which you shared to collinq and noticed you have kept the subjected measures in separate table (no worries it is the best way and everyone does including myself) but the problem arises from there because you reference the table name in the measure. To simplify - if you keep the measure out of its home table you need to reference the home table in the measure or else it is not going to work and and in the other case it is not going to give you correct export data using underlying data export option. 

 

I see your measure is like 

 

Total Calls =
//Calculating discount of callids including Inbound and outbound calls
DISTINCTCOUNTNOBLANK('Calls Data'[Call ID])
 
if you change it to below and house it back to its home table, your problem will get resolved!
 
Total Calls =
//Calculating discount of callids including Inbound and outbound calls
DISTINCTCOUNTNOBLANK([Call ID])
 
Cheers!
 
Hit like if this resolves your issue!