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,
Could someone help me with the following. I want to show for every month the total amount of invoices compared to the total amount of paid invoices.
To calculate the total amount of invoices I use the measure SUM('Invoice Headers'[InvoiceAmt] and for the total amount of the paid invoices I use the measure SUM( 'Payment Behaviour'[PaymentAmount].
When I make for example a barchart, I add the "Month of Year" (maand van jaar) to the Axis and the two measures as the values. But the problem with this is that measure SUM( 'Payment Behaviour'[PaymentAmount] also uses the date that is defined in the 'Invoice Headers' table and not the date 'Payment Behaviour'[PaymentDate]. Does anyone know how I can solve this problem.
Thanks in Advance
Solved! Go to Solution.
Never mind, with some trial and error I found the solution. I had to use the USERELEATIONSHIP function.
Measure = CALCULATE ( SUM ( 'Payment Behaviour'[PaymentAmount] ); USERELATIONSHIP ( 'Payment Behaviour'[PaymentDate]; Datum[Datum] ) )
Never mind, with some trial and error I found the solution. I had to use the USERELEATIONSHIP function.
Measure = CALCULATE ( SUM ( 'Payment Behaviour'[PaymentAmount] ); USERELATIONSHIP ( 'Payment Behaviour'[PaymentDate]; Datum[Datum] ) )
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 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |