pbPassingBI
/
power bi/flashcards/power-bi-cards-dax

DAX calculations — flashcards

One card per lesson — 4 in this module. Recall the key points, then check. 4 cards. Click a card to flip, or use the arrow keys and space bar.

  1. Filter context and CALCULATE — what are the key points?

    Filter context comes from the visual, slicers and filters; measures evaluate inside it · CALCULATE filter arguments replace existing filters unless wrapped in KEEPFILTERS · ALL ignores everything; ALLSELECTED respects slicers — pick deliberately Read the lesson

  2. Time intelligence — what are the key points?

    Contiguous Date table, marked as such, covering complete years · Slice on the Date table, never the fact table date column · Anchor rolling windows on MAX of the date column, not TODAY() Read the lesson

  3. DAX patterns worth memorising — what are the key points?

    VAR evaluates once and captures the context at definition point · Always DIVIDE instead of / ; blank is not zero · RANKX needs an explicit ALL table or every row ranks 1 Read the lesson

  4. FILTER, ALL and ALLEXCEPT — what are the key points?

    ALL ignores everything; ALLSELECTED respects the user selection · ALLEXCEPT removes all filters except the columns you name · FILTER iterates — apply it to the smallest table possible Read the lesson