Forum Discussion

Jungbin's avatar
Jungbin
Frequent Visitor
2 years ago
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 same $767,050 in all row. Can anyone help me?

I uploaded the data here.

 

  • "2023 Sold Lead Amount" measure : SUM 'Leads'[Lead Amount] which has been sold in 'Sales'[Sold Year] 2023.
  • "2023 Sold Amount" measure : SUM 'Sales'[Sold Amount] which has been sold in 'Sales'[Sold Year] 2023 no matter what the 'Sales'[Source] is.

 

 

Need Help
  • devesh_gupta's avatar
    devesh_gupta
    2 years ago

    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.

2 Replies

  • devesh_gupta's avatar
    devesh_gupta
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    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.