Forum Discussion
Analyze in Excel
I can open ods file in Excel. After I connect with power bi account, I can not calculate with all values that I can use in power bi in power pivot table. I can put only measures into Sum value window in pivot table.
I mean only measures will appear in "sum movement". Other values will appear in "movement" and I can not put these values into Sum value window in pivot table.
8 Replies
pstanek yep that is right, you can't put all fields in Values in pivot table as you can do in power bi. You will need to create specific measures in power bi to be able to drop those into Values in pivot table.
I can put no one:smileyvery-happy: only measures works.
When you say specific, you exactly what.
When I want to sum costs, I have to create measure sum(costs).
Or do you mean something else?
Hi pstanek,
I agree with ankitpatira, what you get is expected. If you want to put those numeric fields in Power Pivot table ∑VALUES area, you need to create a measure to aggregate( sum, count, avg,...) those fields in Power BI firstly. For example, the numeric field is [SalesAmount], create a measure called TotalSalesAmount, TotalSalesAmount = Sum(Sales[SalesAmount]). Please refer to this article to create a measure: Tutorial: Create your own measures in Power BI Desktop.
When you open the .odc file which created from "Analyze in Excel", you will find the TotalSalesAmount measure under the ∑ pane in PivotTable fields. You can put it in the ∑VALUES area.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
What you do if yuor dataset is only avaialble from a Content Pack and cannot be opened in PowerBI Desktop? Can you create a measure in the PowerBI Service?
