Removing (BLANK) results COUNTA formula adding IF(ISBLANK(

[Gregpen]

I'm having a little trouble adding the IF(ISBLANK function to a measure to remove the resulting (Blank). When trying to add I get the error that the IF(ISBLANK can only work with 1 argument.

Count of Source for Red =

CALCULATE(COUNTA('Booking Charge Report'[Source]),

    'Booking Charge Report'[Source] IN { "Red" }

)

Thanks

[Greg_Deckler · Accepted solution]

Right, so maybe try this:

Count of Source for Red =
VAR __Value = 
CALCULATE(COUNTA('Booking Charge Report'[Source]),
    'Booking Charge Report'[Source] IN { "Red" }
)
RETURN
IF(ISBLANK(__Value)," ",__Value)

[Gregpen]

Worked a treat, thanks Greg

[amitchandak]

COUNTA will not consider blank,

And if you want blank the try like

Count of Source for Red =
CALCULATE(COUNTX(filter('Booking Charge Report'),not(isblank('Booking Charge Report'[Source]))'Booking Charge Report'[Source]),
'Booking Charge Report'[Source] IN { "Red" }
)

[Gregpen]

Sorry Greg, Just on that solution, it gave the desired effect but now the actual results are showing with 2 decimal places and the option to change this in the format bar are greyed out....

[Gregpen]

Disregard, I figured it out... Thanks.

[Gregpen]

Thanks amitchandak, sorry I'm not sure I understand "And if you want blank then try like" from your reply, are you saying that this will remove the (Blank) result from showing in the visual.