LOD vs table calculation Ask whether the metric belongs to the data grain or the visible table. “Can’t we just use FIXED for every tricky metric?” Your line “FIXED is powerful, but if the question is rank or running movement across visible marks, a table calculation is the natural tool.” Overusing FIXED can freeze the wrong scope and confuse filters. It matches tool to computation job. What is the weighted ratio pattern? SUM(numerator) / SUM(denominator). Use it when totals should reflect volume, such as margin or discount rate. What sentence should precede a percent-of-total calculation? “The denominator should be ___.”…
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in