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?