Forum Discussion
Count zero but not blank
Hi everyone, I have created a measure where I count all sales that have been sold with 0 discount. But my problem is that it also counts all the blank fields in the specific column. Below is my me...
Hello @seryil ,
You must use the strictly equal sign, so your measure should be:
Measure = CALCULATE([Total Sales], Sales[Discount] == 0)check the explanation at the following link:
Hello @seryil ,
You must use the strictly equal sign, so your measure should be:
Measure = CALCULATE([Total Sales], Sales[Discount] == 0)
check the explanation at the following link: