Hello all, I am wanting to create a Custom Column in Power Query : 1. I need to count the number of unique items per customer. BUT I dont want to include the items "All Other" or "Both" in the count. here is an example of the data and the outcome. CustomerItems CustomerItemsCount1Plant 1Plant21Cat 1Cat22Dog 2Dog13Car 3Car14Both 4Both14Bottle 4Bottle15All Other 5All Other06Phone 6Phone26Tree 6Tree2 Is there a good resource I can find info on formulas like this so I dont have to keep asking for help?

FatBlackCat30 try thisMeasure = var _countItems = CALCULATE(DISTINCTCOUNT('Table'[Items]);ALLEXCEPT('Table';'Table'[Customer]);NOT ('Table'[Items] IN ({"Both"; "All Other"}))) RETURN IF(_countItems < 1; 0; _countItems) do not hesitate to give a kudo to useful posts and mark solutions as solution

D count Column in Power Query | Microsoft Fabric Community

Forum Discussion

Related content

Total Count in Column

Counting nulls

Column count duplicates

Count Distinct Values based on another column in Power Query

Count base from other column