DAX

In Power BI DAX, both KEEPFILTERS and REMOVEFILTERS are functions used to manipulate filters within calculations. Let’s delve into each with an example: 1. KEEPFILTERS: The KEEPFILTERS function is used to preserve existing filters while applying new filters within a calculation. It ensures that only the specified filters are applied, keeping all other filters intact. …

KEEPFILTERS and REMOVEFILTERS in Power BI Read More »

The SWITCH function in DAX (Data Analysis Expressions) within Power BI is used for conditional branching. It allows you to evaluate a specified expression against a list of values and returns the result corresponding to the first matching value. If no match is found, it returns a default value. Here’s the general syntax of the …

SWITCH Function in Power BI DAX with Example Read More »

The LOOKUPVALUE function in DAX is used to return a single value from a column based on specified conditions. This function is particularly useful for finding values in a related table without creating a formal relationship between tables. Syntax dax Example Data Assume we have two tables: ProductInfo and SalesData. ProductInfo Table ProductID Category 1 …

LOOKUPVALUE Function in Power BI with Example and Data Read More »

The TREATAS function in Power BI is used to apply the result of a table expression as the filter to columns from an unrelated table. It effectively changes the context in which data is evaluated, enabling cross-table calculations without explicit relationships. Here’s an example to illustrate the TREATAS function with example data: Example Scenario Suppose …

TREATAS function in power bi DAX with example and data Read More »

The RANK and RANKX functions are commonly used in DAX (Data Analysis Expressions) within Power BI, Power Pivot, and SQL Server Analysis Services to rank data within a dataset. Here’s a detailed explanation of each: RANK in DAX The RANK function is generally not available directly in DAX. Instead, the RANKX function is used for …

RANK and RANKX Function in Power BI Dax Read More »

In DAX (Data Analysis Expressions), which is used in Power BI, Excel Power Pivot, and SQL Server Analysis Services, ALL and ALLExcept are functions used for manipulating the context of calculations, particularly in measures and calculated columns. These functions are primarily used to remove or modify filters in a DAX expression. Let’s delve into each …

All and All Except in Power Bi DAX Read More »

The HASONEVALUE function in DAX is used to determine if a column has a single distinct value in the current context. This can be particularly useful in scenarios involving measures, where you want to ensure that a calculation is performed only when there is exactly one distinct value present in the column. Syntax dax Return …

HASONEVALUE Function DAX Power BI with examples Read More »

In Power BI, the RELATED function in DAX (Data Analysis Expressions) is used to fetch a related value from another table. It works within a row context to retrieve a corresponding value from a related table, which is linked through a relationship. Here’s a basic explanation and example of how the RELATED function works: Syntax …

RELATED Function Power BI DAX with Example Read More »