Unit Price = Sales[Revenue]/Sales[Units] Unit Price M = SUM(Sales[Revenue])/SUM(Sales[Units]) Count Rows = COUNTROWS(filter(Sales,Sales[Units]>50)) SumX Filter = SUMX(FILTER(Sales,Sales[Units]>50),Sales[Revenue]/Sales[Units]) SUMX Revenue = SUMX(Filter(Sales,Sales[Country] = "USA"),Sales[Revenue]) SUMX All = SUMX(ALL(Sales),Sales[Revenue]) SUMX Filter All = SUMX(FILTER(ALL(Sales),Sales[Country] = "USA"),Sales[Revenue]) Calculate = CALCULATE(SUM(Sales[Revenue]), Sales[Country] = "USA") CalculateUSAAliqui = CALCULATE(SUM(Sales[Revenue]), Country[Country] = "USA", Manufacturer[Manufacturer] = "Aliqui") CalculateAll = CALCULATE(SUM(Sales[Revenue]), ALL(Sales)) CalculateAllSelected = CALCULATE(SUM(Sales[Revenue]),ALLSELECTED(Sales)) Calendar = CALENDAR(min(Sales[Date]), max(Sales[Date])) Calendar = CALENDAR(date(year(min(Sales[Date])),1,1), Date(YEAR(max(Sales[Date])),12,31)) Revenue YTD = TOTALYTD(sum(Sales[Revenue]),'Date'[Date]) Revenue Same Period LY = Calculate(sum(Sales[Revenue]),SAMEPERIODLASTYEAR('Date'[Date])) Revenue DateAdd LY = Calculate(sum(Sales[Revenue]),DATEADD('Date'[Date],-1,YEAR)) YoY IF = IF( [Revenue DateAdd LY] > 0, SUM(Sales[Revenue])/[Revenue DateAdd LY],BLANK())