Forum Discussion
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...
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
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