DaxStudio / DaxStudio

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Desktop, Power Pivot for Excel, and Analysis Services Tabular.
http://daxstudio.org
Other
686 stars 143 forks source link

Pivot Table Problem #1034

Closed BurimBehrami closed 1 year ago

BurimBehrami commented 1 year ago

Area Values doesn't work

When I import data from PBI to Excel with Dax Studio, I can't put any field to area Values.

Here is the message:

image

Thanks in advance!

dgosbell commented 1 year ago

It looks like you've done something else to the data after you exported it. I can see multiple tables in your PivotTable field list. Have you imported the data into a data model in Excel or something? Whatever manipulation you have done the issue seems to be related to that.

SharmaAntriksh commented 1 year ago

@BurimBehrami If you have a Calculation Group in the model then Implicit Measures are discouraged by default so this isn't a problem of DAX Studio instead a design choice from PBI Team.

dgosbell commented 1 year ago

Closing due to lack of response