Quiz

  1. 1
    Advanced

    How many ALL() functions can you include in the filters of your CALCULATE() measure?

  2. 2
    Advanced

    In the example measure below, how do we add a function to remove filters for locations? =CALCULATE([Sales $],ALL('Calendar'[Year]))

  3. 3
    Advanced

    The following chart was created with Sales $ in the values and End of Month on the axis. You want to retain the total of $2.7m of Sales $ in a card when any data point is clicked. Which formula will do that for you?