Forum Discussion
Counting Blanks in a Card
Well, COUNT "Counts the number of rows in the table where the specified column has a non-blank value." so that will probably explain where the number 82 comes from. Presumably you have 82 records with value = 1.
Now CARD visualisations don't like filters so that bit of your post confused me. See if you can edit the filter for your card. I'd be interested if you can. Sometimes they display a filter condition if the visualisation started out as something else and was changed but it won't be doing anything.
Looking at your DAX, can't you solve this issue by swapping the result clauses in your IF statement, like so
“NoBaselineDate = IF(ISBLANK(ProjectBaselines[ProjectBaselineFinishDate]), 1, BLANK())
so you get a 1 in the column if it has no finish date. Pull the column on to a card. You can make that work for your table as well but you'll have to change the filter
- RichJW7 years ago
Helper III
Thanks HotChilli,
Appreciate the advice, I'll have to wait until Monday to test now, as Power BI again refuses to find user.zip as it loads up! A reboot usually resolves that.
Rich
- v-danhe-msft7 years ago
Microsoft Employee
Hi RichJW,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
- RichJW7 years ago
Helper III
Hi Daniel,
The fix didn't work, however I'm trying to seek internal support, so I can be more transparent with the data.
Thanks,
Rich