tried to count the DISTINCTCOUNT supplier for certain equipment and it always count blank cell although it should be zero its counting the blank.

CountQuote:=CALCULATE(DISTINCTCOUNT(Bids[Manufacturing Company]); Not(isblank(Bids[Manufacturing Company])))
CountQuote:=CALCULATE(DISTINCTCOUNT(Bids[Manufacturing Company]); FILTER(Bids;Not(isblank(Bids[Manufacturing Company]))))

0 Answers