cannot add a field to values section on a pivot table in Excel

Anonymous

Are you using “Analyze in Excel” function? I think you can take a look at this thread which has the similar problem with you. You need to drag Measure into Values field but not normal fields.

Best Regards,

Herbert

Thanks for the comment v-haibl-msft . Pardon me if I'm asking a silly question. My understanding is that 'measure' is a single value. So how can I use a 'measure' instead of a field? And how can I create a measure to imitate the field that I'm trying to add? 

Thanks in advance.

Anonymous

Please refer to this document about how to create a measure in Power BI Desktop.

Best Regards,

Herbert

Creating measures is not a challenge but what's the rationale for this? It's extremely inefficient if I have to create a measure for every field I want to use as a value in my pivot table. The fields already exist in the database and they are already assigned as SUM fields. This is completely backwards and makes the Analyze in Excel feature useless in many cases. v-haibl-msft can you please explain the technical reason for this?

Thanks,
Mick

let me support mickjaeger question

I agree.  This is silly and makes the analyse function pointless

in my case I have all my fields as numeric so why I still need to declare as measures. I may want to use same numeric field as average or sum or count or with statistical function. so why is it has to be decaled as measure. 

thanks