IF Function DAX
IF function is a Power BI logical function in DAX that checks whether a condition is satisfied, and returns one value in case of TRUE else another value in case of FALSE.
Home »
Measure in Power BI
SUMX Function DAX
SUMX() is a power bi DAX Math function that returns the sum of an expression evaluated for each row in a table. It returns a decimal number.
It goes through a table, row by row to complete the evaluation after filter is applied.
Only the numbers in the column are counted. Blanks, logical values, and text are ignored.
It can be used to evaluate expression over multiple columns as it has the ability to work row by row.
CALCULATETABLE function DAX
CALCULATETABLE function is a power bi filter function in DAX that evaluates a table expression in a context modified by the given filters. It returns a table of values.
DAX SYNTAX
CALCULATETABLE(
ALL Function DAX
ALL is a Power Bi DAX filter function that returns all the rows in a table or all the values in a column, ignoring any filters that might have been applied.