I have a very simple BI model and measure, and can’t for the life of me determine if the issue is my model or the way use put the measure together. I had this working at one point but I’m afraid it may have been dumb luck so I went back to the basics. The issue is this.
I have two visuals,
1 - select the serial number
2 display the related Service order numbers in the adjacent visual
Works as expected.
Now add the measure I created and show the aggregate parts cost. this is pulled from the second fact table called Parts Cost. Every time I add the measure, all the serial numbers get displayed versus the one I have selected in the first visual. My model is using the serial number as the primary key. I have included my the pbix file. What am I over looking?
Equipment Service history 3.pbix (296.0 KB)