Disruption due to formula

[salonikhedkar_1]

When we select "Show items with no data", a blank row appears. How to fill the blank row with 0 ?

I have tried this formula:

if(isblank(calculate(sum(amount), sameperiodlastyear(date))),0,calculate(sum(amount), sameperiodlastyear(date))))

But this formula disrupts other column which is driven by an IF statememt:

if(Country = "United States of America" && month(date)>=1 && month(date)<=3, 100,

If(Country = "United States of America" && month(date)>=4 && month(date)<=6, 200,

if(Country = "United States of America" && month(date)>=7 && month(date)<=9, 300,

if(Country = "United States of America" && month(date)>=10 && month(date)<=12, 400)

it is adding extra 0's in the visual.

I am totally confused on why the first formula is caused such big issues.

Appreciate your quick responses.

[Greg_Deckler]

Really difficult to answer, can you post your PBIX or images or Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490