Forum Discussion

LABrowne's avatar
LABrowne
Icon for Helper II rankHelper II
2 years ago

Count formula: How to exclude values from count based on text

Hi there,   Currently have the below formula.   CALCULATE ( COUNT ( Table[Column] ), filter('table',[SpicyLevel (%)] >1 &&[No. of Orders] >= 2 && TODAY () <= [Expiry Date Less 90 Days]) )   ...
Amerluzz's avatar
Amerluzz
New Member
2 years ago

Might not be the best way, but in PQE you can add a conditional column with a "Contains" clause. If Order Number contains "Cancelled" --> "Cancelled",  else --> "Active".

Then calculate your measure where your new column = "Active"