Condition to count/sum/avg including blank in power bi

[Charu]

Hi Everyone,

I need to take count includes blank help me to achieve this, here is the sample for your reference

I need to display the Customer count with blank also and when I filter based on Id suppose Id is 1 then the count of a customer is 1 and when Id is 5 the count of a customer should display Zero as It's blank

how to create the measure for this logic?

one measure which takes the count of all rows includes blank and then when I filter for blank row it should display as ZEro

thanks in advance

[Zubair_Muhammad]

Hi @Charu

Please try this MEASURE

Measure =
IF (
    ISCROSSFILTERED ( Table1[Customer] ),
    COUNT ( Table1[Customer] ),
    CALCULATE ( COUNT ( Table1[Customer] ), Table1[Customer] <> BLANK () )
)

[Charu]

HI @Zubair_Muhammad

I tried this measure It's returning (Blank) when I select Id =5,Instead blank I need to display ZEro

[Zubair_Muhammad · Accepted solution]

Hi @Charu

Please try this then

Measure =
VAR mymeasure =
    IF (
        ISCROSSFILTERED ( Table1[Customer] ),
        COUNT ( Table1[Customer] ),
        CALCULATE ( COUNT ( Table1[Customer] ), Table1[Customer] <> BLANK () )
    )
RETURN
    IF ( ISBLANK ( mymeasure ), 0, mymeasure )

[Charu]

Thanks a lot, It's working...