New Measures corrupts data integrity

Hi HotChilli , thank you for looking into that.

Actually the Column "Art" is in the table LU_KONTORAHMEN, which is joined to the merged table. so all entries for account 7109 should get the same "Art"-Value assigned.

Yes, "Wert" is measure - but even if  i show all columns (which would lead to SUM(Wert) == Wert, because i am on the lowest aggragation level), this happens.

I understand the first picture of the table ISTSOLLVGL looks ugly. but this is a full outer join showing accounts with budgets and actual bookings. it is possible that we dont have a match, but still need those value in the report.

my join key is period, branch and account.

to avoid null values in my non-measure values, i have created  coalesce-similiar columns, where i use a logical like this:

branchall=

if table1.branch is null, then use table2.branch

etc.

hope this makes sense 🙂 if i can provide you with any info (data dump ..) to support you help, let me know!

really appriciate it!