Analyze in Excel - Error Message

[PBI-Curious]

Hello PBI Community

I'm getting an error message while trying to create a pivot table in Analze in Excel. 

I was able to put business unit name in rows, but received the following error message when trying to put reveneue amount in value.

This is a simple pivot table, nothing complicated.

Much appreciate your help!

Thank you

[PBI-Curious]

Hello otravers

I forgot about that, understood,

Thank you

[otravers · Accepted solution]

You can't drag Power BI implicit measures as values in an Excel pivot table, you need to add the equivalent explicit DAX measure in your source data model.