Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Countrows with multiple criteria

Hello everyone, Thank you for your time, I'm struggling creating a measure, hopefully you guys can help me. Basically it's a countifs in excel but I just can make it work in DAX. Here's an exampl...

DavisBI

5 years ago

Hi, Anonymous ,

In this case you need to use EARILER(). (see screenshot below)

Column = 
CALCULATE (
    COUNT ( Sheet1[Date] ),
    'Sheet1'[Customer ID] = EARLIER ( Sheet1[Customer ID] ),
    'Sheet1'[Date] = EARLIER ( Sheet1[Date] ),
    ALL ( Sheet1 )
)

Mark this post as solution if this helps,thanks!

saumitra

Helper I

5 years ago

Hi DavisBI,

I also have a similar problem, however I am not getting the desired outcome from the solution that you provided. I am attaching a screenshot, kindly please take a look at it.

So what I want is that, if Ash's name pops up for the first time for Forbes then the count should be 1. However, if it again pops up for the same company i.e. Forbes for Ash, then I want it to count as 2, as it is coming for the 2nd time and so on.

I am attaching an excel sample also, for you to understand what excel formulae I am using.