Fixed Calculation Tableau Direct

But LODs require you to think .

You try a standard calculation: MIN(Order Date) . fixed calculation tableau

FIXED [Sub-Category] : MAX([Sales]) Wait, that gives me a number, not a flag. But LODs require you to think

Imagine you have a dataset with 10,000 rows. A FIXED calculation runs once, creates a temporary lookup table (e.g., 100 unique customers), and then pastes that result back onto every relevant row. that gives me a number

You are experiencing the tension between and Aggregate Level calculations.