Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Using not equal Blanks in DAX not returning correct total

Hello, I am using this DAX statement for a measure:   n value = CALCULATE(COUNTROWS('Donor NPS'),FILTER('Donor NPS',[NPS]<>BLANK()))   I then use "n value" as the Value in a matrix, with no rows...
Need Help
  • ray_aramburo's avatar
    ray_aramburo
    2 years ago

    The COUNT will iterate only on the specified column, while COUNTROWS considers the whole table. That can make the difference to narrow down the problem. Glad it worked for you 🙂 

ray_aramburo's avatar
ray_aramburo
Super User
2 years ago

Is it possible for you to share your .pbix file? 

In the meantime, other suggestions would be to try the following measures:

n value1 = CALCULATE(COUNT(Donor NPS[NPS]), Donor NPS[NPS] <> BLANK())

or

n value1 = CALCULATE(COUNT(Donor NPS[NPS]), Donor NPS[NPS] <> "")