Forum Discussion

PBINoob_v3's avatar
PBINoob_v3
Frequent Visitor
3 years ago
Solved

How to avoid Blank

  After filtering the data, both Day and Total Qty are blank.There is no data of last 40 days, so the dashboard is Blank. How to display 0 on the dashboard? [Day] and [Total Qty] does n...
Need Help
  • PBINoob_v3's avatar
    PBINoob_v3
    3 years ago

     

    Hi, DOLEARY85 Jihwan_Kim 

    I solved problem.

    Of course  need to create a measure for [Total Qty], but still to make a little change on [Date].

    I created a table that data is from Today to Last 40 days.

    And I related the [Date] and [Day]:

    Finaly, it displayed ZERO.

    Thanks for your help!

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi, 
Plrease try creating a new measure that looks something like below.

 

New Measure: =
[Total Qty] + 0
  • PBINoob_v3's avatar
    PBINoob_v3
    Frequent Visitor
    3 years ago

    Hi,

    This is my measure:

    total_line2 =
    var _sales = SUM('ProdManual Line_Line2'[Total Qty])
    return
    IF(ISBLANK(_sales),0,_sales)
    It doesn't work. Maybe it is [Day] 's problem
    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      Hi,

       

      try this:

       

      total_line2 =
      var _sales = SUM('ProdManual Line_Line2'[Total Qty])
      return
      COALESCE(_sales,0)
       
      If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
      • PBINoob_v3's avatar
        PBINoob_v3
        Frequent Visitor
        3 years ago

        It is still Blank. 

        [Day] and [Total Qty] are blank in the table, because there are no data of last 40 days.

        Maybe i should create a measure for [Day]?