Yes you can, nevertheless not refer, but calculate the same value.
I think in this case the sum(MAPE) is fair enough. Thanks to data modell the value of KPI will follow the selections as well your table. (If it isn't fulfill your requirement some tip : set expressions, aggr() function and so on.
That is an average total. See the problem I'm facing is I want to calculate mape. In the above figure. I want to the average of all the rows in MAPE column. The fields in the Mape column are calculated it depends on sales and baseline forecast.
I've created a measure which is calculating (abs(Sale-Forecast)/sale). This is shown in the MAPE column. Now when i change the total to average it gives me the mean of it which is MAPE.
I want to show this mape(calculated value) in a KPI or any other way in which I can calculate MAPE.
This is giving me correct Absolulte%Error which is shown in the first figure under mape column. If I change the totals column to average I get MAPE. Which is what I want but when I use this formula in a KPI it's applying this formula on the Total's of Sales & Forecast instead of applying on each row then take an average.
That's why I wanted to know if it's possible to refer table total value.