Matrix pulling in overall average instead of specific average/data dissapearing.

[Anonymous]

I have been messing with this for a couple days. I want to see the overall sum of the average sales price of all of these parts for each section, and the sum of the overall average sales price of the sections for each sytem.

I have the matrix set up correctly finally. But now it is pulling in the overall average price of everything, instead of specific to the material. "Avg Sales Price" is a measure I created.

I thought this was  an issue of tying "material" from 'TD System Group' to "material" in 'Main Data' which is where I created the "Avg Sales Price" measure (note this relationship doesn't exist in the first picture).

When I add this relationship however, a lot of the material part numbers dissapear from the matrix, is there any idea why?

I know  they exist in the "Material" section of "Main Data", and that there is data for them. There has to be a way to pull in the average price for these part numbers, instead of the overall average price of everything. Or to keep these part numbers from dissappearing.

[Wilson_]

GSB0302,

Without knowing the data in your tables, the solution might simply be to turn the two bi-directional relationships to single direction relationships (with the tables on the right filtering the table on the left). Bi-directional relationships should be very rare in your data model. I'm assuming your tables on the right are dimension tables and the table on the left is a fact table.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.