Running Count of Companies By Month

[jasprice]

Hello,

I am trying to create a measure that will allow me to count the number of companies in my data set after the company has reached a specific stage.   The data is based on a process flow and stage 3 is the final stage.

Pseudo code for calc would be:

Running Count = Count the number of [Company Name] by Month[Stage Date] where Stage = 3

Table fields are:

Company Name

Stage

Stage Date

I have seen a number of examples of running sums based but I am new to DAX and need a bit of assistance.

Thanks.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Anonymous · Accepted solution]

With Month on rows you can use the following code that will give you the count of companies in stage 3 during that month

Running Count=
CALCULATE(
    COUNTROWS( TABLE ),
    TABLE[STAGE] = 3
)

[jasprice]

Thank you!