Forum Discussion
Assistance with PQE and visuals
I resolved this by adding a dax measure to both of my fact tables and now it works splendidly. Feel free to mark this resolved.
Hi nprevallet ,
Based on your description everything is setup correctly the only question is what fields are you bringing from each table.
The dimension table (the one side of the relationship) must be used for the information that is common to all table that will allow you to get information from the different facts however this may depend on the type of data because if you are doing a sum it should work properly, however if you are getting the detailed information of a text field, getting all values (on the many side) for each table then you will get an error because the details will not have a match.
Can you please explain a little bit better what is the expected result and what fields you are using.
My product code table includes the code, description, division, franchise, business unit, and legal manufacturer. Additionally, the two Excel sheets that I linked to the product code table via the ProductIndex will bring in deliverable dates related to the product codes. I also want to bring in a risk classification for each product code.
So in summary:
- I have one product code table containing the core product details.
- Two additional sheets provide deliverable dates for specific product codes.
- One of those sheets also includes the risk classification for certain codes.
I hope this clarifies things rather than making them more confusing.
Hi nprevallet ,
In this case you have several dates for each product code and also several risk classifications is that it? And you want to bring each line of the two tables into a single visual.
Yes, exactly. Each spreadsheet corresponds to a project which contains product codes and a deliverable date. One of the sheets also has a risk classification which corresponds to a product code. I want to bring the deliverable dates and risk classification into 1 visual, and that visual also will contain details of the product codes being pulled from salesforce.