1. 1

    In the formula below, what does the pipe character (|) stand for? Sales $ - Beer = CALCULATE([Sales $],Categories[Category]="Draft Beer"||Categories[Category]="Burgers")

  2. 2

    Assume that you have stored your Product ID numbers as text, and want to write a CALCULATE() function to return product 54698 only. Which version of the function will work?

  3. 3

    The image below was snapped from a single page on a report. The bar chart uses a formula that generates as follows: Sales = SUM(Transactions[Amount]). What is the formula used to generate the $1.4m showing in the yellow box?