Forum Discussion

kg4u's avatar
kg4u
Helper II
3 years ago
Solved

Sum with multiple criteria

Hi,   I have reviewed and searched on this forum for ideas and suggestions.  While I did find a couple of suggestions which I thought would work, neither option I found is giving me the results as ...
Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    kg4u you are using wrong value in your measure, missing "d" from some of the value, here is the correct measure. Pay attention to your data.

     

    Quality Sales = 
CALCULATE (
    [Total Sales],
    KEEPFILTERS (
        'Quality Data'[Status] in { "Issued Paid", "Issued Paid|ARF", "Issued Paid|PDR", "Issued Paid|NY PIF", "Issued Paid|PDR|NY PIF" }
    )
)

     

    and here is the output

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Does this measure work

Quality Sales2 = CALCULATE(SUM('Fact Agency Data'[Original Sales]),'Fact Agency Data'[Status] = "Issue Paid"||'Fact Agency Data'[Status] = "Issue Paid|ARF"||'Fact Agency Data'[Status] = "Issue Paid|PDR"||'Fact Agency Data'[Status] = "Issue Paid|NY PIF")

If it does not, then share the download link of your PBI file.

kg4u's avatar
kg4u
Helper II
3 years ago

I tired both the options as suggested and neither is returning the results as expected.

Quality Sample 

I think I have a copy of the file with the data and measures linked above for your review.  I certainly do appreciate your assistance.  

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Wrong spelling - use "issued" instead of "issue".  Try this measure

     

    Quality Sales2 = CALCULATE([Total Sales],'Quality Data'[Status] = "Issued Paid"||'Quality Data'[Status] = "Issued Paid|ARF"||'Quality Data'[Status] = "Issued Paid|PDR"||'Quality Data'[Status]= "Issued Paid|NY PIF")