How to disabled the (blank) in card visual

[Frixel]

Hello all,

If I make a new messure I create a table to remove the outcome (blank) how should I do that?
I tried with:

No Blanc =
IF ( ISBLANK ( COUNTA('Table'[Sales] ) ), 0, COUNTA('Table'[Sales] ) )

and with 

No Blanc =
IF ( ISBLANK ( SUM ( 'Table'[Sales] ) ), 0, SUM ( 'Table'[Sales] ) )

But the problem is that I don't have the option's sum and count anymore.

How can I best approach this to display in a card visual the number of a column and also the number of items in a column?

[Frixel · Accepted solution]

I found this formule thats works fine for me.

LegeRegels = CALCULATE(COUNTROWS('ExportFile'),FILTER(ExportFile,'ExportFile'[Remark] = BLANK()))+0

[AlexisOlson]

FYI, this calculates the number of rows where Remark is blank.

[Frixel]

@v-jingzhang @Ashish_Mathur @AlexisOlson 

Thanks all for the response but i don`t understand what i mus do with the formules you given (Sorry)

This is what i have. Must i make a new messure with the given formule en that is then what i set in 'Fields' or is the formule for insert elsewhere in ' count of stock' ?

[AlexisOlson]

Create new measure(s). These will then show up in the Fields pane and you can drag them into the Visualizations pane Fields area instead of the Stock column.

[Frixel]

@AlexisOlson When i do that then still i have ' Blank' 

What do i wrong?

[AlexisOlson]

It looks like there are no rows where Stock is not blank, so it's returning a blank result.

The simplest fix is probably to add " + 0" to the end of your measure definition since blank + 0 returns 0.

[Frixel]

@AlexisOlson 

oke now i have a zero as result with this measure

but now, how do i get that in here when i wil see the result of the stock? 

[AlexisOlson]

The whole point of writing the measure is to use instead of the column...

If you want the sum, use a summing measure. If you want a count, use a counting measure. Defining new measures will never change how using a column works (i.e. implicit measures).

[v-jingzhang]

Hi @Frixel 

You can also add +0 at the end of SUM or COUNTA. This will turn blank to 0. 

No Blanc = COUNTA('Table'[Sales])+0

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Frixel]

Let me explain,

I have this table 

i get this in the visual Card.

When i change 'null' for 0 

then i get this.

i expect there also (zero)0

[Ashish_Mathur]

Hi,

Do not replace the null with 0 in the Query Editor.  Write this measure:

Measure = calculate(countrows(data),data[stock]<>blank())

[Ashish_Mathur]

Hi,

Why do you need the option to sum and count when you are writing a measure?  Anyways, please simplify your measure to:

No Blanc = coalesce(COUNTA('Table'[Sales]),0)

[Frixel]

@Ashish_Mathur 

Then i get this error

[Ashish_Mathur]

There should only be 1 closing bracket after 0.

[AlexisOlson]

Those measures look reasonable. Why do you expect sum/count in the dropdown if you've already included those aggregations in the measures you're using?

[Frixel]

@AlexisOlson 

Because i need it for the results in card visual. In this new messure i can`t select a count or sum 🙄