Count records with status T before today

[icturion]

Hi,

I'm trying to make a measure that counts the times a value is present before today.

This is what i got so far:

MO_T_STATUS_BeforeToday = Calculate(Countrows(AQZ_SAMP_VIEW);AQZ_SAMP_VIEW[MO_Status]="T")<TODAY()

The problem is that the measure returns "true" instead of the times the status has occurred.

Icturion

[ChandeepChhabra · Accepted solution]

Try writing something like this

MO_T_STATUS_BeforeToday =
CALCULATE (
    COUNTROWS ( AQZ_SAMP_VIEW ),
    FILTER (
        AQZ_SAMP_VIEW,
        AQZ_SAMP_VIEW[MO_Status] = "T"
            && AQZ_SAMP_VIEW[Date Column] < TODAY ()
    )
)

Note that I have referenced a dummy date column which I am expecting that you'll have in your data

Thanks