Forum Discussion

leejoel's avatar
leejoel
Helper I
6 years ago
Solved

Help with table not displaying '0' value

I have a table displaying customer claims (OPEN and CLOSED). Currently for the year, there are no OPEN claims and 27 CLOSED claims. The table is only displaying the 27 CLOSED claims because there are...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    leejoel you need to create separate table for status and then it will work, see attached,  I created a sample pbix file, change it as per your need

     

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

leejoel's avatar
leejoel
Helper I
6 years ago

az38and aj1973 Attached is a sample report around what I am trying to do. Even though there are no Open claims I would still like to display the 'Open' field and '0' value. This is pulling directly from a database so it does work when values are present, but when no value is present then it is completely omit from the report and I don't like that.

 

I tried to attach the source file but I don't know how to do that...

DATE   CUSTOMER_CLAIMS   TARGET #   ACTUAL #   WEEK   INCIDENT_ID

5/15/2020 12:49:49 PM

Closed

0

183

20

21528

5/12/2020 12:49:49 PM

Closed

0

183

20

21494

5/12/2020 12:49:49 PM

Closed

0

183

20

21493

5/1/2020 12:49:49 PM

Closed

0

183

18

21491

4/22/2020 12:49:49 PM

Closed

0

183

17

21431

4/1/2020 12:49:49 PM

Closed

0

183

14

21287

4/1/2020 12:49:49 PM

Closed

0

183

14

21291

3/25/2020 12:49:49 PM

Closed

0

183

13

21225

3/5/2020 12:49:49 PM

Closed

0

183

10

21031

3/5/2020 12:49:49 PM

Closed

0

183

10

21021

3/5/2020 12:49:49 PM

Closed

0

183

10

21028

3/5/2020 12:49:49 PM

Closed

0

183

10

21018

 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    leejoel you need to create separate table for status and then it will work, see attached,  I created a sample pbix file, change it as per your need

     

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

     

    • leejoel's avatar
      leejoel
      Helper I
      6 years ago

      parry2kThat works! You have no idea how much time I've spent messing around with this. You are a life saver.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        leejoel oh my pleasure! Glad I could help. All the best!

  • aj1973's avatar
    aj1973
    Community Champion
    6 years ago

    Hi leejoel 

     

    Try using COUNTAX instead with the expression when it is CLOSE and OPEN.

    https://dax.guide/countax/

     

    As i became not sure what exactly you want to achieve, it would be better if you provide me with a dummy PBIX file! you need to provide it through Dropbox or Google Drive...there is no way to attach it in here

     

    Thanks