The other studies did not show any positive effect.
Then you didn't read the 4 studies I linked to, all 4 showed positive effects. If you discount only one of them that leaves 3.
#1 : Vitamin D administration results in a decreased risk of death and ICU admission (standardized mean difference (95% CI): 0.49 (0.34–0.72) and 0.28 (0.20–0.39), respectively). The TSA of the protective role of vitamin D and ICU admission showed that, since the pooling of the studies reached a definite sample size, the positive association is conclusive. The TSA of the protective role of vitamin D in mortality risk showed that the z-curve was inside the alpha boundaries, indicating that the positive results need further studies. Discussion: The results of the meta-analyses and respective TSAs suggest a definitive association between the protective role of vitamin D and ICU hospitalization.
#2 : A total of 6 RCTs with 551 COVID-19 patients were included. The overall collective evidence pooling all the outcomes across all RCTs indicated the beneficial use of vitamin D intervention in COVID-19 (relative risk, RR = 0.60, 95% CI 0.40 to 0.92, Z = 2.33, p = 0.02, I2 = 48%). The rates of RT-CR positivity were significantly decreased in the intervention group as compared to the non-vitamin D groups (RR = 0.46, 95% CI 0.24 to 0.89, Z = 2.31, p = 0.02, I2 = 0%). Conclusively, COVID-19 patients supplemented with vitamin D are more likely to demonstrate fewer rates of ICU admission, mortality events, and RT-PCR positivity.
#3 : In summary, a 2-week oral supplementation of 5000 IU vitamin D3 was superior to 1000 IU in resolving cough and gustatory sensory loss among COVID-19 patients with sub-optimal vitamin D presenting with mild to moderate symptoms. The present findings add to the growing body of evidence on the beneficial effects of vitamin D supplementation against COVID-19, particularly among those with suboptimal levels.
#4 : Conclusion: A 5000 IU daily oral vitamin D3 supplementation for 2 weeks reduces the time to recovery for cough and gustatory sensory loss among patients with sub-optimal vitamin D status and mild to moderate COVID-19 symptoms