on 2020 Jun 16 9:27 PM
Hi. I have the following design on a Calculation View:
I'm facing a problem with the result of Join_7.
If I check Aggregation_3 and Aggregation_2, I have a dataset which has a unique key:
They Key marked in red is unique. Therefore I expect that, when joining these two aggregations. I can have all measures in one table for further processing.
This is the Join (Inner Join with no cardinality defined):
However, this joing brings the values of ber_menge and bet_wert multiplied by four.
Since there is a one-to-one relation between the two aggregation I expect to have all the values combined, and not multipled. (ber_menge should be 4577 for the first 4 records and 111,2 for records 5 to 8).
All measures in both aggregations are calculated columns, calculated before the aggregations (in previous aggregations or joins) but this only happens with these two measures.
What I tried (with no success):
Any help will be very much appreciated.
User | Count |
---|---|
69 | |
12 | |
11 | |
10 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.