Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
28 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
51 | |
45 | |
16 | |
12 |