Forum Discussion
Countif multiple conditions met
Hello, I am trying to create a measure that will give me the quantity of items that meet multiple criterias. I have part numbers that may show up in the column more than once, so would want...
this formula doesnt return the actual number i am looking for, it just returns a count of how many unique part numbers there are.. so its ignoring me trying to ask for items less than 0
CountPurItemStock2 =
CALCULATE(
DISTINCTCOUNT('Perseverance BOM'[No.]),FILTER(AllMeasures,AllMeasures[InvCalgaryMinusRequired]<0),'Perseverance BOM'[Make/Buy]="Purchase")