Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Making null a zero when using 'Count' of a column

Hi All!   What I am trying to achieve as an end goal is a line chart where the nulls are treated as zeros so lines remail consitant.   I unfortunatley can not show the data I am working with, as ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Create a Month dimension table which is linked to fact data table based on [Month] field.

    Month dimension = VALUES(Table7[Month])

     

    Add [Subject] into chart legend. Add below measure to line chart rather than using Count for Subject column.

    Countvalue = COUNT(Table7[Subject])+0

    Best regards,

    Yuliana Gu

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

In general, you use a line like this in your measure:

 

Measure =

...


RETURN
IF(ISBLANK(__var),0,__var)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the input! trouble is I am not using a measure, I am using the count [Column] in the vizulaization editor.

     

    I am happy to write a measure to do this, however, the top subjects will change as more data is added, or as date slicers are applied, so I cant make subject specific measures.

     

    Kind Regards

    Matt

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      7 years ago

      Can you give me a sense of your data? Just make up data that emulates your real data using "apple", "orange" or "foo" and "bar", etc.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi!

         

        Thanks for looking at this. I have posted a very small dataset as an exmple in the body of the message. Also a small extra bit to try and help explain. 

         

        Kind Regards

         

        Matt