Forum Discussion
Solved
SUM with Conditions
Hi there! I have two tables: Leads, Sales. Below are result matrix I want & I see. I made "2023 Sold Lead Amount" measure but I failed to make "2023 Sold Amount" measure which returns the sa...
Jungbin you can try:
2023 Sold Amount = CALCULATE(SUM('Sales'[Sold Amount]),filter(ALL('Sales'), 'Sales'[Sold Year] = 2023))If you find this insightful, please provide a Kudo and accept this as a solution.
devesh_gupta
Impactful Individual
Impactful IndividualJungbin you can try:
2023 Sold Amount = CALCULATE(SUM('Sales'[Sold Amount]),filter(ALL('Sales'), 'Sales'[Sold Year] = 2023))If you find this insightful, please provide a Kudo and accept this as a solution.
Hi devesh_gupta !
Thank you so much, it works!