Measure not show correct with Filter pass trough datamodel

[hansolu]

Hi

I do have an actual not so complicate Datamodel.
Its one Facttables with Production Data (tblsOSPR) and number of ok parts and another fact table with scrap data(tblScrap)
Then some dimensiontables with MachineID, ScrapID, ArtikelID, Date

What do I want: Create a Pivottable where I can drill down from total ScrapRate for a period to day and shift for each machine and articel and then also down to Scrapreasons.

Base for good parts is the first Operation (Col. OP) for each Articel in tblOSPR
With the help of this board I created a measure for my OKparts based on the firstOP

This is either taking the OK pcs for each operation, based on the drill down level.

Now comes my issue. To be able to trigger the filter into my DimScrap table, I made another measure

Please Login or Register  to view this content.

Thats working great.
If I show the OKFirst measure, i will see all scrapReasons and the value for OKFirst in each row.
But with OKFirstCalculate I only see the rows with values for Scrap and the ScrapReason.

My problem is now the dimension shift.

In the attached example I created a Pivottable to show the problem.
Machine Turn1 had scrap data in Shift 1 and 2. If I move the shift dimension to the row, everything is fine
But if I delete or collapse the SHift dimension, my aggregation for the measure OKFirstCalculate does not aggreate the OK pcs per Machine, it shows the aggregation per shift.

What i do not understand is why. OkFirstOP is correct, just show in every row for each scrapreason, just passing the filter through with calculate is changing the result.


Any ideas why this is happening?

thanks a lot