Lock filter from measure result but not from visualization

gitguto — Wed, 11 Aug 2021 02:41:46 GMT

Hello community,

I have a measure "Inventory" that is calculated through an accumulative sum expression:

RangeSum(Above(Total Sum({<[Year],[Month]>}Inventory),0,RowNo(TOTAL)))

Notice that I have to exclude the possibility to filter the dimensions Year and Month as it would affect the calculated result. This is because I have inventory data since the beginning of my operation, and the current inventory is the sum of all entries (negative entries indicating outbound movement).

My problem is, I need to display in a table the inventory month by month. Using this expression as the measure, I get the correct values for each month, but the user can't filter the year and/or month to narrow their analysis without affecting the value shown.

Notice that even though the year dimension is filtered to only show 2021, I got entries from all the historical data.

Does anyone know a workaround to lock the filter from the measure result, but not from the visualization?

P.S. If I try RangeSum(Above(Total Sum(Inventory),0,RowNo(TOTAL))), the result will be wrong as it would only calculate the cumulative sum from the months that are filtered.

topic Lock filter from measure result but not from visualization in App Development

Lock filter from measure result but not from visualization