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.

     

     

     

parry2k's avatar
parry2k
Super User
3 years ago

kg4u you need to update a measure like this, I would not go with the path suggested by Anonymous 

 

Quality Sales = CALCULATE(

[Total Sales],
KEEPFILTERS(
'Fact Agency Data'[Status] in {"Issue Paid", "Issue Paid|ARF", "Issue Paid|PDR", "Issued Paid|NY PIF", "Issued Paid|PDR|NY PIF" }
)
)

 

✨ 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.