Forum Discussion

Clint's avatar
Clint
Helper V
7 years ago
Solved

Understanding results returned by CountAX function

Hello,   I have a table that has records with various status values.  Ideally, I'd like to count all records except for those in certain statuses but I have not been able to figure out the dax to m...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago
    Hi Clint try the following measure,

    COUNTAX (
    FILTER (
    'Boydenhancements',
    'Boydenhancements'[Status] IN { "Removed", "N/A", "Completed", "Not Approved" }
    ),
    'Boydenhancements'[Status]
    )

    Regards,
    MFelix
MFelix's avatar
MFelix
Super User
7 years ago
Hi Clint try the following measure,

COUNTAX (
FILTER (
'Boydenhancements',
'Boydenhancements'[Status] IN { "Removed", "N/A", "Completed", "Not Approved" }
),
'Boydenhancements'[Status]
)

Regards,
MFelix
  • Clint's avatar
    Clint
    Helper V
    7 years ago

    Thank you MFelix , this worked perfectly.