sql starts with filter

When you use a measure in a pivot table for example it produces different results for each cell because the same expression is ev…