The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
69 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
40 | |
29 | |
24 | |
23 |