Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Do not count duplicates DAX Formula

Hi Everyone,   I am having trouble getting a calculation that works like a COUNTIF in PowerBI.    If this is my database     and I am looking for and end result like this   In Proce...
Need Help
BA_Pete's avatar
BA_Pete
Super User
5 years ago

Not dumb - I do it ALLLL the time!

Glad it's working for you 🙂

 

Pete

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I know why was not working in the beginning. while testing data for example

ALBEMA2-2040596 Rejected status is getting counted and that is exactly what I DO NOT need. Does this make sense?

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    Not sure.

     

    Do you mean that as soon as ANY [Carrier Reference] is rejected, you don't want any more to be counted?

    ...or do you mean that you want all others to be counted but not ALBEMA2-2040596 specifically?

    ...or do you mean it works just fine now, but you found why is wasn't working for you originally?

     

    Pete

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I found why the simple DISTINCTCOUNT is not working for what I want to achieve.

       

      The problem is that the invoice perhaps was sent twice, it was once rejected and once payed. for this particular analysis i just want to know the count for the times it was payed