Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Analyze in Excel - Error Message

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 messa...
  • otravers's avatar
    4 years ago

    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.