I need to build KPI summary by month. The paramitor for kpi is "Spending amount of on time/Total spending in that month" below is my Dax formular. The issue here is there is no "On time" status in August and that the mattrix doen't show any value while I would like to display 0% in August.
Thank you very much for your suggestion. My database has Mar,Apr,May, Jul, and August which in August I have 0% KPI and that because there is no ontime value. Is it possible to distinquist between 0% KPI and not applicable data? In my case I don't want to display Sep - Dec because data is not yet available. In addition, April>>location B should be blank instead of 0%. Not applicable data and 0% value has different meaning in this case.