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.
Hi,
I have 2 tables, Clean Data, and Deposit details.
I have made a relation with the File ref Column, and matched the Liability per GL (from the Deposit details table), and the Amount column ( from the Clean Data)
I want to make a measured column which give me the sum, so that I can make sure that there are no file refs that have over or under balances.
Not sure if a measured column is the correct way to go about this problem.
Solved! Go to Solution.
Hello @Anonymous
You want to create three measures. Rather than just pulling [Liability per GL] and [Amount] directly from the tables you write a measure to sum them so you can use them in other measures.
Total Liability = SUM ( 'Deposit Details'[Liability per GL] )
Total Amount = SUM ( 'Clean Data'[Amount] )
Then your compare measure looks like this
Remainder = [Total Liability] + [Total Amount]
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
Hello @Anonymous
You want to create three measures. Rather than just pulling [Liability per GL] and [Amount] directly from the tables you write a measure to sum them so you can use them in other measures.
Total Liability = SUM ( 'Deposit Details'[Liability per GL] )
Total Amount = SUM ( 'Clean Data'[Amount] )
Then your compare measure looks like this
Remainder = [Total Liability] + [Total Amount]
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |