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

Hi Anonymous ,

 

I may be oversimplifying your scenario, but I believe a simplification of your measure should work fine:

_yourMeasure = DISTINCTCOUNT(RawData[Carrier Reference])

 

When you apply this using [Life Cycle Status] as a dimension it should give you what you want.

 

Pete 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

wow....I am not sure why was i overcomplicating things, i feel dumb!!

  • 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