Excel Power Pivot Data Model

0 votes
I'm working on what I assumed would be a fairly straightforward data model in Excel (not Power Bi). I have three distinct tables (Parts, Equipment, and Configurations). Equipment is made up of parts, and configurations are made up of equipment. Then, I have two "allocation" tables that allocate Equipment to Configurations and Equipment to Parts.

See the picture in the attachment. This includes the unprocessed tables, the relationship from the data model, and the flawed pivot table.

I'm not obtaining the right values in the pivot table when I connect everything in the data model. I'm rather certain that Excel's data model's one-direction restriction is what's causing the problem. Exists a more effective method to model this data? or is there an alternative? I've read about cross filters, but do I need to create one for each field in my tables?
Nov 15 in Others by Kithuzzz
• 20,660 points
23 views

1 answer to this question.

0 votes
Here is the answer for your question: https://www.contextures.com/excelpivottableerrors.html
answered Nov 15 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
306 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
6,168 views
0 votes
0 answers

Importing notepad data to excel (difficult split)

I want to transfer this data from ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
65 views
0 votes
1 answer

Downloading Tableau data into Excel (scientific notation column)

Due to Excel's internal floating point numbering ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
58 views
0 votes
1 answer

Using Multiple filters in DAX

CALCULATE is defined as CALCULATE(<expression>,<filter1>,<filter2>…) This means that you can ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,890 points
4,083 views
0 votes
1 answer

Average TIME Calculation differs between Excel and PowerBI

They are calculating different things. In Power ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
323 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
89 views
0 votes
1 answer

Updating Powerpoint - Excel Link in Different Computer

You could look at the Excel shape's ...READ MORE

answered Oct 14 in Others by narikkadan
• 37,660 points
54 views
0 votes
1 answer

Use Excel pivot table as data source for another Pivot Table

Press the keys Alt+D+P in a new ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
49 views
0 votes
1 answer

Excel VBA if file closed, then open and paste, else just paste data

Slightly re-worked to add full workbook/sheet qualifiers ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
86 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP