Force Zero for dates using measure

[whysotan]

Hello,
I have a data sheet that has a list of dates and I need to count how many times those dates show up. Problem is there are some dates that do not show up at all and result in a blank. I need them to show 0 on my visual and I believe the method is to force them to be 0 instead of blank. Is there a measure to force zero for dates?

[mwegener]

Hi @whysotan ,

did you solve your problem?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[whysotan]

@mwegener sorry was out of the office. I will try those methods later this week and get back to you guys.

[v-yuta-msft]

@whysotan ,

Try creating a calculate table using dax below:

Column = Table[Data] + 0

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @whysotan,

could you provide sample data or a screenshot 

[whysotan]

Hello @mwegener,

Here's a picture of the visual.

As you can see there's some months not showing anything at all and I'd like to have them display 0 instead, main reason is relative date filtering doesn't appear like it works properly if there's any null or blank dates.

[mwegener]

Hi @whysotan ,

what is your measure?

Maybe this helps:

CountRows =

VAR _CountRows = COUNTROWS('Table')

RETURN

IF(ISBLANK(_CountRows);0;_CountRows)