AnalystReps

DAX practice: Preserving Filters with KEEPFILTERS

Chapter 11 · 3 questions · included in full access

  1. Question 1 · medium

    KEEPFILTERS vs filter replacement

    A table visual has Products[Category] on rows. Why does CALCULATE([Total Sales], KEEPFILTERS(Products[Category] = "Sheets")) show blank for Profiles?

    Solve it in your browser

  2. Question 2 · medium

    Keep the filter

    Write Sheets Kept: total sales for Sheets, using KEEPFILTERS so other categories show blank.

    Solve it in your browser

  3. Question 3 · medium

    North Kept

    Write North Kept: sales for the North region, using KEEPFILTERS so other regions show blank.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing