Forum Discussion
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 ...
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
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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