Forum Discussion
Ignore filter/selected value
You are going to need a measure, that measure will need to make use of the an ALL() function to ignore the filter context.
ALLEXCEPT() may need to be used instead, should there be some amount of filters to be kept. For example you might have a location filter, but you still want data of all time.
You are going to need a measure, that measure will need to make use of the an ALL() function to ignore the filter context.
ALLEXCEPT() may need to be used instead, should there be some amount of filters to be kept. For example you might have a location filter, but you still want data of all time.
I was able to show the data as expected with the allexcept however how can I ignore rowcontext but include filter on slicer. Below is my report. I'm able to show the history which has Blank forecast dates even when the forecast date is not selected. My formula includes filter on start month and product line. Everything works as expected. However I want to use the weighted average of the total history selected in the report. But the report context is coming into picture here. Last column is the sum of the history for the selections made. I want to show the sum as 159405 in all rows. However the sum is shown 27108 for 003 and 132297 for 006. How can I override the row context but make sure the product line filter in the slicer is applied. Below is the formula I have for the measure test
test = CALCULATE(SUM('V_FORECASTACCURACY'[DeliveryQty in SU]), ALLEXCEPT(V_FORECASTACCURACy,V_FORECASTACCURACY[PROFITCENTERBRAND],V_FORECASTACCURACY[STARTMONTH],V_FORECASTACCURACY[STARTWEEk],US_MATERIAL[Product Line]))