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.
I'm trying to create a total transaction amount from a table (SalesLines) of the individual sales lines.
I created a new table (Table) with the distinct transaction numbers and I tried to create a new column using the DAX formula:
=CALCULATE(SUM(SalesLines[NetAmount]),Table[TransactionNumber])
But I recieved the error: "Cannot convert value '(individual transaction number)' of type Text to type True/False."
I've seen similar threads but no solution has worked for me. Thanks for any help!
Solved! Go to Solution.
Hi @Anonymous,
Create a measure instead of column using the following DAX and check if you get expected result. If not, share sample data as other post.
Measure = CALCULATE ( SUM (SalesLines[NetAmount] ), FILTER ( SalesLines, CONTAINS ( Table, Table[TrasactionNumber] , SalesLines[TransactionNumber] ) ) )
Thanks,
Lydia Zhang
Hi @Anonymous,
Create a measure instead of column using the following DAX and check if you get expected result. If not, share sample data as other post.
Measure = CALCULATE ( SUM (SalesLines[NetAmount] ), FILTER ( SalesLines, CONTAINS ( Table, Table[TrasactionNumber] , SalesLines[TransactionNumber] ) ) )
Thanks,
Lydia Zhang
Hi,
Is it possible to share sample data, it could be data type issue?
Prathy
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |