Forum Discussion
Count 0 Values in Table
I have a table with a list of all Accounts & their sales I need to flag all Accounts what have 0 sales My Sales Measure is; var TYQTY = [TY Qty] return IF(ISBLANK(TYQTY),0,TYQTY) TY...
if it's in the same table then you can just go, but this might be too simple to understand this issue. Can you share the actual data you using in text format? Including the columns you are using to derive your measures
CALCULATE(DISTINCTCOUNT('Sale Data'[Account No.]) , sales = 0)