Counting Blanks in a Card

[RichJW]

Hi,

I am trying to make a Card visualisation display the same number of rows it is displaying in my Table, however I seem to be having such difficulty.

Apologies, I am a basic user of Power BI and have not touched upon DAX, so forgive me if this is simple. I have about 5 similar reports to do, so feel as though if I am helped with one, then that should help me with my others.

So, I have a Table visualisation looking at Projects with no baseline date (the field would be blank). My calculation to get this data into the table is this…

“NoBaselineDate = IF(ISBLANK(ProjectBaselines[ProjectBaselineFinishDate]), BLANK(),1)”. I then filter on the data less than 1.

This helps me to pick the blanks out the list and it shows the 6 projects affected in a table (6 is the correct number).

However, if I make this a Card visualisation, it shows 82, not 6. In the “Fields” section, it is showing as “Count of NoBaselineDate”. I’m guessing I need to make a new measure, but really don’t know what to put in to look for blank fields. The filter (…is less than 1) is still in place in the Card.

Any help appreciated.

Rich

[HotChilli]

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

[RichJW]

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-msft]

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

[RichJW]

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