Pivot with measure and zero values

[nicolas877]

Hi forum, i have a table with thousands of rows like this

Week	Sales	Returns
1​	4000​	150​
2​	1250​
3​	7800​	340​
4​	3444​

I tried to create a pivot table (using data model option) to create a Return Rate measure (returns/sales) but i got an error message always, i suppose is because of the empty fields in returns...how can resolve this ? thanks

 

[nicolas877]

Update : actually what i need it just a third column in the pivot but i cannot mage to do it

Count Of sales , Count of Returns, Return rate (count of sales/count of returns)