Skip to main content

    Power BI

    Declined

    Count should return 0 instead of (Blank)

    Vote (575) Share
    Stephane Viot's profile image

    Stephane Viot on 07 Oct 2015 23:52:58

    Count of should return 0 instead of '(Blank)' (looks better on a Dashboard)

    Administrator

    You can do this with the COALESCE function: https://docs.microsoft.com/en-us/dax/coalesce-function-dax. For example:

    = COALESCE(SUM(FactInternetSales[SalesAmount]), 0)
    Comments (54)
    Stephane Viot's profile image Profile Picture

    Scott ssugar on 05 Jul 2020 22:14:35

    RE: Count should return 0 instead of (Blank)

    Would definitely prefer count to be 0 instead of (Blank).

    Stephane Viot's profile image Profile Picture

    Hasan on 05 Jul 2020 22:13:58

    RE: Count should return 0 instead of (Blank)

    i am having the similar problem

    Stephane Viot's profile image Profile Picture

    Robert Smith on 05 Jul 2020 22:08:50

    RE: Count should return 0 instead of (Blank)

    Yes. I'm having the same eyesore on my dashboard.

    Stephane Viot's profile image Profile Picture

    Henry on 05 Jul 2020 22:08:28

    RE: Count should return 0 instead of (Blank)

    Yes, just created a new dashboard for us, but it would look better if it displayed 0 and not Blank.