Good day,
i have received a request where i should only measureA where measureB has data
1 Dimension: Trip_TripNo
Fact MeasureGroup A: Count Trips
Fact MeasureGroup B: trip detail order qty
Mease A & B is the same source byt aggrageted at different levels, and the link to Trip DImension on Trip_No
I know i can enable unrelated measure=false
however the dm link is the same and i find Measue shows values where measureB has no data
i was thinking of working the count in measureB to have 1 measure but the count would be incorrect due to the detil of trp it includes
Any ideas please?
regards