Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need to calculate the balance receivable from the total invoice according to the context of the table below:
The problem is that the invoice amount is repeated across the lines.
It is necessary to calculate in DAX taking into account the invoice number (In the example 165995) the invoice amount (121,558.46) and the sum of the amounts received (75,288.80).
Return = 46,269.66
I manage to get this result, but only when I filter the invoice, when I remove the filter from the invoice, I no longer have the result.
I need to add the receivable amount in both contexts of the attached images.
Considering the invoice amount - total receipts
Thanks
Hi @josimarjr
what should be the expected result of the first context?
What exactly have you tried and exactly was the problem?
HI @tamerj1
Basically I want to calculate in DAX the amount of the invoice (In the example 165995) and value (121,558.46) minus the sum of the amounts received (75,288.80).
Return = 46,269.66
The big problem is that the invoice amount is repeated because of the number of receipt lines.
Thanks
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |