NEED HELP! Show zero with measure in line chart is not apply date filter

[ssuzjzuss]

I tried using +0, and it displayed the value 0, but when I used +0, it caused my visualization not to filter data using the date filter. I also tried filtering with the min-max date obtained from the date slicer, but it didn't work either.

Filter:

Not show zero (Data in april):

DAX my measure:

(CALCULATE(COUNT([Count passed]), support_table[Count passed] = 1) / COUNT([id]))*100

With show zero:

DAX my measure:

(CALCULATE(COUNT([Count passed])+0, support_table[Count passed] = 1) / COUNT([id]))*100

Does anyone have any other suggestions?

Thank you in advance.

[ssuzjzuss]

Hi Sakiko,

Thank you very much for your suggestion. That works for me!

Do you have any reason about different between / (slash) and divide function?

[DataNinja777]

Yes.  I was always told when I started learning DAX many years ago to use divide function instead of / slash, because slash when dividing by zero will cause #NUM error.  Since that time, I avoided using / as a divisor and always have used divide function.  

DIVIDE function vs divide operator (/) in DAX - DAX | Microsoft Learn 

[DataNinja777 · Accepted solution]

@ssuzjzuss 

What about the formula below?

Are the columns [Count passed] and [id] both in the table, 'support_table'?  I wasn't sure which table(s) those columns belonged to.  

v