DAX cheat sheet for Power BI

Total Sales = SUM ( Sales[Amount] )
Orders = DISTINCTCOUNT ( Sales[OrderID] )
AOV = DIVIDE ( [Total Sales], [Orders] )
Customers = DISTINCTCOUNT ( Sales[CustomerID] )

Coffee Sales =
CALCULATE ( [Total Sales], 'Product'[Category] = "Coffee" )

Coffee (keep slicer) =
CALCULATE ( [Total Sales],
    KEEPFILTERS ( 'Product'[Category] = "Coffee" ) )

% of Total =
DIVIDE ( [Total Sales],
    CALCULATE ( [Total Sales], REMOVEFILTERS ( 'Product' ) ) )

% of Visible Total =
DIVIDE ( [Total Sales],
    CALCULATE ( [Total Sales], ALLSELECTED ( 'Product' ) ) )

Sales LY = CALCULATE ( [Total Sales],
    SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
Sales YTD = TOTALYTD ( [Total Sales], 'Date'[Date] )
Sales MTD = TOTALMTD ( [Total Sales], 'Date'[Date] )
Sales PM = CALCULATE ( [Total Sales],
    DATEADD ( 'Date'[Date], -1, MONTH ) )

Sales YoY % =
VAR Curr = [Total Sales]
VAR Prev = [Sales LY]
RETURN DIVIDE ( Curr - Prev, Prev )

Sales Rolling 3M =
CALCULATE ( [Total Sales],
    DATESINPERIOD ( 'Date'[Date],
        MAX ( 'Date'[Date] ), -3, MONTH ) )

Revenue = SUMX ( Sales, Sales[Qty] * Sales[Price] )
Avg Daily Sales =
AVERAGEX ( VALUES ( 'Date'[Date] ), [Total Sales] )
Max Order = MAXX ( VALUES ( Sales[OrderID] ), [Total Sales] )

Big Customers =
COUNTROWS (
    FILTER ( VALUES ( Customer[CustomerID] ),
        [Total Sales] > 1000 ) )

Product Rank =
RANKX ( ALL ( 'Product'[ProductName] ),
    [Total Sales], , DESC, DENSE )

Selected Region =
SELECTEDVALUE ( Store[Region], "All regions" )

Title = "Sales for " & [Selected Region]

IF ( ISBLANK ( [Sales LY] ), BLANK (), [Sales YoY %] )
SWITCH ( TRUE (),
    [AOV] >= 50, "High",
    [AOV] >= 25, "Medium",
    "Low" )
COALESCE ( [Total Sales], 0 )