Count a distinct value within the same colu,m

[CSmith]

I have a column in my report, Tracking Status, that can have a value of Active, Pending, Canceled, or Rejected. Is there a way to, for example, only count the Active statuses?

I have tried creating a measure with the following formulas, none of them worked.

aggr(Count(TRACKING_STATUS), TRACKING_STATUS = 'Active')

If(Count(distinct TRACKING_STATUS = 'ACTIVE')=1,TRACKING_STATUS,1)

Count(IF(TRACKING_STATUS,'Active'))

Count(Distinct TRACKING_STATUS='Active')

[ramchalla]

Hi,

Try the below formula

Count({<[Tracking Status] = {'Active'}>} [Tracking Status])

[Chanty4u · Accepted solution]

Try this.Sum(If(TRACKING_STATUS='Active', 1, 0))

[CSmith]

Thank you Chanty4u/MVP. This worked perfectly!!