Trying to show 0 in each row of a Matrix Visual

[akhaliq7]

I have a matrix visual, in the row field have sales persons and in the values trying to add a measure, the measure is currently defined as below:

Holidays = 0

But when I add this measure a blank row is returned under sales persons. Can anyone help me with this.

FYI: The reason the value is at 0 is because this measure is going to be a placeholder.

[Ahmedx]

pls try this

Measure = LEN(MAX('sales' [persons]))*0

[akhaliq7 · Accepted solution]

IF(DISTINCTCOUNT('Table'[Department ID]) = 1, 0, BLANK()),

Using an if statement and distinctcount has solved my problem

[Anonymous]

see if this blogs helps:
Show rows for attribute with No values – SQL Server Business Intelligence & Analytics (thomas-leblan...

[akhaliq7]

I have taken a look at the link above, I don't think this is what I am look for, the article refers to showing rows with no values, but I am not trying to do this instead I want to show a 0 for every row in the department field inside a matrix, this 0 is hardcoded and does not belong to a column and/or table.