Forum Discussion
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...
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.
Hi,
Can you share the DAX used for the measure?
Thanks.
Hi!
I'm simply using the 'count distinct' function for value (no of appointments).
Hi,
Can you try using DISTINCTCOUNT( column ) + 0
Thanks.