Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone
I'm having trouble solving this problem.
I have a Transaction table and an item table.
In my Transaktion tabel i have a lot og columns where i wanna use the 'transaktion amount' and 'transaktion key'
In the Items table i wanna use the 'transaktion key' and the 'item registration fee'
I want to sum 'transaction amout', for the whole transaktion table, but where the transaktion wich is registered i the items table as a "court_fee or 'registration' are deducted.
So if a transaktion is a court_fee og a registration they should NOT be a part of the sum of the transaktion amount.
I sorted so. both tables are only march 2022 - Where the first photo is the items table and the second is the transaktion table.
Solved! Go to Solution.
Transaction Amount Measure = SUMX( 'transaction table',
var itemFees = CALCULATE( SUMX( RELATEDTABLE( 'items' ), 'items'[item registration fee]),
NOT( 'items'[item type] IN { "court fee", "registration fee" } )
return itemFees + 'transaction table'[transaction amount]
)
Transaction Amount Measure = SUMX( 'transaction table',
var itemFees = CALCULATE( SUMX( RELATEDTABLE( 'items' ), 'items'[item registration fee]),
NOT( 'items'[item type] IN { "court fee", "registration fee" } )
return itemFees + 'transaction table'[transaction amount]
)
Hello John!
Thank you very much! it worked! i just had to do some formating but everything else is perfect.
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
85 | |
52 | |
37 | |
23 |