Table values show for all dates when filtered with year where blanks are replaced with zeros

[kamalbandam]

Hello,

I have a measure that has Blanks when it kept in the table values. So I replaced the blanks with zeros using Dax i.e 
If(ISBLANK(Measure),0,Measure)

The problem is that in the table it showing the values of the previous year too even though when I filter the data.

Can anyone help?

Thanks in advance.

[v-xicai]

Hi @kamalbandam ,

Could you please show us your [measure] in formula and issue sceemshot for further analysis? You may also try to share your data sample by uploading it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy 

[kamalbandam]

Hi @v-xicai ,

I have used this formula to replace blanks = If(ISBLANK(Measure),0, Measure).

The issue is like we have two tables as follows:

The right table has no values for 2009 and 2010 so it is blank and not displaying. So, when I used the above measure the left table is showing all values.

[v-xicai]

Hi @kamalbandam ,

From your description, would you like to get one blank row when you filter data,  instead of two blank rows for 2009 and 2010?

Best Regards,

Amy 

[amitchandak]

@kamalbandam , you have re-enforce the filter on this statement

calculate(If(ISBLANK(Measure),0,Measure),filter(Date,...)

As it creates a left join in such cases and give all values

[kamalbandam]

Hi @amitchandak,

I have tried it, but it didn't work.
Could you provide an alternative solution?