Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

To include 'no data' in chart

I've created a chart that visualises the count of appointments by sales reps (linking 2 separate tables to obtain the required info). The chart is filtered using month of appointment as well as sales...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    You should be able to just add 0 to the measure this will return the distinct count (if there are some observations else it will return 0).

    count distinct = DISTINCTCOUNT( 'fact'[column]) + 0

    If this work then please mark it as the solution and if it does not work would you then please provide some more information about your issue, i.e. a screen dump and a data sample.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You should be able to just add 0 to the measure this will return the distinct count (if there are some observations else it will return 0).

count distinct = DISTINCTCOUNT( 'fact'[column]) + 0

If this work then please mark it as the solution and if it does not work would you then please provide some more information about your issue, i.e. a screen dump and a data sample.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Silly me! I added this as a new measure but I forgot to change the value used for the visualisation. Anyway, thanks!