In Power BI's DAX language, there are several information functions that allow you to obtain information about data, columns, or expressions within your dataset. Here are some of the most commonly used information functions along with examples:
HASONEVALUE: Checks whether an expression has only one value in the current context.
IF(HASONEVALUE(Sales[Product]), "Single Product", "Multiple Products")
This example returns "Single Product" if there is only one product in the current context, otherwise it returns "Multiple Products".
ISBLANK: Checks whether a value is blank.
IF(ISBLANK(Sales[Quantity]), 0, Sales[Quantity])
This example returns 0 if the Quantity column is blank, otherwise it returns the value of the Quantity column.
ISERROR: Checks whether an expression evaluates to an error.
IF(ISERROR(1/0), "Error", "No Error")
This example returns "Error" if the expression results in an error (e.g., division by zero), otherwise it returns "No Error".
ISEMPTY: Checks whether a table is empty.
IF(ISEMPTY(Sales), "No Sales Data", "Sales Data Available")
This example returns "No Sales Data" if the Sales table is empty, otherwise it returns "Sales Data Available".
ISFILTERED: Checks whether a column has been filtered in the current context.
IF(ISFILTERED(Date[Year]), "Filtered by Year", "Not Filtered by Year")
This example returns "Filtered by Year" if the Year column has been filtered in the current context, otherwise it returns "Not Filtered by Year".
ISSUBTOTAL: Checks whether a row is a subtotal row.
IF(ISSUBTOTAL(Sales[Quantity]), "Subtotal", "Not Subtotal")
This example returns "Subtotal" if the current row is a subtotal row, otherwise it returns "Not Subtotal".
These functions can be useful in various scenarios, such as conditional formatting, creating dynamic measures, or handling errors in calculations.
Comments
Post a Comment