DAX functions
The functions behind almost every Power BI report. Each page has the syntax, what every argument does, worked examples with real results, and the mistakes to avoid.
Aggregation
Counting
Logic
Filter
- CALCULATEEvaluates an expression after changing the filters it runs under.
- FILTERReturns the rows of a table that meet a condition.
- ALLReturns all the rows of a table, or all the values of columns, ignoring filters.
- REMOVEFILTERSClears filters from a table or columns, inside CALCULATE.
- VALUESReturns the distinct values of a column (or the rows of a table) visible in the current filters.
- SELECTEDVALUEReturns the value of a column when exactly one value is filtered, otherwise an alternate result.
Iterator
Relationship
Time intelligence
Text
No function matches. Try another name.