Not recommended. Step-2: Now create a new column in Product table. This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. Volatile. The RELATED DAX function in Power BI is a powerful tool that allows users to establish relationships between different tables within a data model. This function is not supported for use in. groupBy_ColumnName. Creating Time-Intelligence Functions in DAX; DAX is Microsoft’s new(ish) language which allows you to return results from data stored using the xVelocity database engine, which, unlike for most databases, stores data in columns rather than rows. Total Sales = SUM ('Sales'[SalesAmount]) The SUMX function in DAX is an iterator function that applies a. In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set of features you have in SQL, a few text comparison functions in DAX are only case-sensitive and others only case-insensitive,… » Read more. Like RELATED. What we need is to add prices from the pricelist to the table of sales. The problem is that when I used the =RELATED () DAX function, the function returns blanks and I don't know why. The use of this parameter is not recommended. USERELATIONSHIP can only be used in functions that take a filter as an argument, for example: CALCULATE, CALCULATETABLE,. Using RELATED function in DAX with USERELATIONSHIP. It takes one argument: the name of the column in the related table to retrieve the value from. Related functions. A. The RELATED function is just one of the many DAX (Data Analysis Expressions) functions available in Power BI that enables accurate revenue forecasting. This function enables users to navigate and explore the data model, retrieve data from connected tables, and perform calculations based on these relationships. Evaluates an expression for each row of a table and returns the largest numeric value. In this blog, we learn the 4 relationship functions of DAX with practical examples. The use of this parameter is not recommended. A calculated column expression, where the current row context is unambiguous. Measures and calculated columns both use DAX expressions. Read related article. to create the sum of sales, follow the steps given below. This function is deprecated. Both can be used to assign values from other table - similarly to VLOOKUP in Excel. Learn more about MINX in the following articles: Highlighting the minimum and maximum values in a Power BI matrix. Show 11 more. Not recommended. How can I use DAX to create measures? Ans. Learn how to work with the RELATED and RELATEDTABLE function in DAXLearn SUMX - - - - My Courses - - - - ️ Maste. 3. The use of this parameter is not recommended. The RELATEDTABLE DAX function is used to retrieve a table that is related to the current row according to the defined relationships in the data model. Many of the functions in DAX are similar to the Excel date and time functions. The full expression we need to use is =[qty] * RELATED(Products[Sales Price] As with all DAX expressions, we start with equals. This can save a lot of time when writing DAX formulas. Before diving into the specifics of the RELATED function, it is. » Read more. The field of data analysis and DAX functions is constantly evolving. There are two types of context: Row Context and Filter Context. By defining relationships, Power BI can accurately calculate ratios and perform other complex calculations based on the connected data tables. End Date: The date you want to count the difference to. DAX Nesting Multiple IF. It allows users to define custom calculations based on specified conditions. Luckily, in SQL 2012, DAX has been enriched with the ISFILTERED function, which lets you detect whether a column has been filtered or not. If you’re familiar with functions in Excel formulas, many of the functions in DAX will appear similar to you; however, DAX functions are unique in the following ways: The Power BI RELATED function is a Relationship function under DAX (Data Analysis Expressions) function used to retrieve a single value from a related table based on a defined relationship. Any DAX expression that returns a single scalar value, that is to be sought in columnName. These functions help you create calculations based on dates and time. However, there are some built in DAX functions which can take advantage of existing relati. Statistical Functions: They are associated with statistical distributions and probability, such as standard deviation and number of permutations. As a nested. As your DAX skills improve, you will create formulas using many different functions. = RELATED(ColumnName) ColumnName is the column name you want to retrieve values from (must reference a table on the “one” side of a many-to-one relationship). Returns a table with one column of all dates between StartDate and EndDate. I assume history date is the extract date, so you would end up with potentially 2 date columns. As soon as one value matches, the corresponding result is returned, and other subsequent values aren’t evaluated. The RELATED function returns a single value that is. Optimizing date-related DAX functionsBy following these best practices,. From SQL to DAX: String Comparison. Right-click on the table and choose “New measure. So, if they are similar, which one should be used in which situation? Why to use RELATEDIn other words, the expression returns the sum of freight charges for only the specified sales area. For specific scenario, it works. This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. If omitted, BLANK is returned. RELATED: Returns a related value from another table. Somewhat obviously, fees, taxes, insurance, reserve payments, and other costs associated with loans are computed and. It supplies comprehensive information related to the syntax, parameters, data types, and returns values for the 250+ functions stored in the DAX library. From this blog, you got some idea about 3 important filter functions (LOOKUPVALUE, SELECTEDVALUE, RELATED. How to Use RELATED DAX function in Power BI for Financial Modeling Understanding the basics of DAX functions in Power BI. A volatile function may return a different result every time you call it, even if you provide the same arguments. Step 2: To check, use Card visualization and drag SalesSum on the canvas. DAX Functions Filter - You can use DAX Filter functions to return specific data types, look up values in related tables and filter by related values. DAX RELATED function needs a row context. The RELATED DAX function is an essential feature in Power BI that allows users to establish relationships between tables. Jump to the Alternatives section to see the function to use. If a relationship does not exist, you must create a relationship. Multiple columns in the same predicate should be used only when necessary. Deprecated. In DAX string comparison requires you more attention than in SQL, for several reasons: DAX doesn’t offer the same set of features you have in SQL, a few text comparison functions in DAX are only case-sensitive and others only case. This function is deprecated. This function effectively bridges the gap between disparate tables, providing. COUNT and COUNTA are identical in DAX for all the data types except Boolean. Functions like FILTER, ALL, and RELATED are integral components of the DAX toolkit. Learn more about MAXX in the following articles: Highlighting the minimum and maximum values in a Power BI matrix. Volatile. Deprecated. The RELATED DAX function is used to retrieve values from a related table in Power BI. Not recommended. . DAX RELATED function needs a row context. Conclusion. » Read more. 1. By using the RELATED function effectively, you can create comprehensive reports and dashboards. สิ่งสำคัญของการใช้งาน Power BI ที่ขาดไม่ได้และเป็นเรื่องสำคัญมาก ๆ อย่างหนึ่งนั้นคือ DAX (Data Analysis Expressions. Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models. See Remarks and Related functions for alternatives. » 6 related articles. A measure is a formula that is created specifically for use in a PivotTable (or PivotChart) that uses Power Pivot data. Step 2: Create a relationship between the two tables. This will create a simple star schema, and the DAX should be easier. I am getting the. In addition to running totals, rolling totals, month-to-date, quarter-to-date, year-to-date, and averages, window. Some DAX functions return a table instead of a scalar, and must be wrapped in a function that evaluates the table and returns a scalar; unless the table is a single column, single row table, then it is treated as a scalar value. If you’re familiar with functions in Excel formulas, many of the functions in DAX will appear similar to you; however, DAX functions are unique in the following ways:The Power BI RELATED function is a Relationship function under DAX (Data Analysis Expressions) function used to retrieve a single value from a related table based on a defined relationship. RELATED DAX Function (Relationships management) Syntax | Return values | Remarks | Examples | Articles | Related Returns a related value from another. DAX can be used to create measures in a number of ways. » Read more. RELATED DAX function • When you have a one-to-many relationship between a fact table and a dimension table, you can use the RELATED function on the fact table many-side to perform an exact match lookup. A measure is a formula that is created specifically for use in a PivotTable (or PivotChart) that uses Power Pivot data. I am trying to pull in a field from another table in my BISM model using the "RELATED" function. BITOR = BITOR(BITWISE[Number1],BITWISE[Number2]) Power BI Bitwise XOR (BITXOR) DAX BITXOR function returns a bitwise XOR of two numbers. ”. Jump to the Alternatives section to see the function to use. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. The. DAX Patterns: Standard time-related calculations. ISFILTERED is your best friend when it comes to detect which level of a hierarchy you are browsing. Microsoft believes that the cardinalities of the two end points are unimportant, the key difference between this type of relationship and the existing relationships is that it only supports cross-filtering, but not other semantics. You may concatenate string values, search for text with string, and return a portion of a string using DAX Text Functions. e. So you can try to update your formula like this. DAX Text Functions. Related articles. The LOOKUPVALUE function retrieves the two values, Campaign and Media. I want to add column itemcategory_category in the items table based on the left join =ADDCOLUMNS ( items, LOOKUPVALUE (. RELATED and RELATEDTABLE should be used here. Even if the relationship is inactive, it will be used and overrides. A measure is evaluated in the context of the cell evaluated in a report or in a DAX query, whereas a calculated column is computed at the row level within the table it belongs to. I always recommend using. Without the IN operator, a possible alternative was storing the list of values in a separate table, similar to the one called Selection in the following. table. Ask Question Asked 10 years, 10 months ago. This is an in-depth video lecture of the Related distinct count pattern. Context: The context refers to the row that has been included in the formula for data retrieval or calculation. Example This formula computes the increase or decrease ratio in sales compared to the previous year. The syntax of the RELATED function is: RELATED (<column>) where <column> is the name of a column you want to use from a related table. By leveraging the RELATED DAX function, organizations can gain deeper insights into their cost structures, identify cost-saving opportunities, and make data-driven decisions to optimize their operations and profitability. Create table. See Remarks and Related functions for alternatives. Returns a table that contains the Cartesian product of all rows from all tables in the arguments. The SUBSTITUTE function is case-sensitive. Such column(s) will be used to join the two tables and produce the result. The RELATED DAX function can be leveraged to implement dynamic pricing analysis in Power BI. I am talking about RELATED and LOOKUPVALUE. Here is a step-by-step guide to help you implement the RELATED DAX function for risk assessment in Power BI: Identify the tables and data sources that contain relevant information for risk assessment. DAX queries return results as a table right within the tool, allowing you to quickly create and test the performance of your DAX formulas. It comes under Relationship functions category. The RELATED DAX function can't be used to retrieve the "one" side column values ; Enforcing RLS has topology restrictions . Techniques such as scenario analysis, sensitivity analysis, and what-if analysis can be. 2: It is the equal (=) operator which represents the beginning of the DAX syntax and also equating the two sides. Any DAX expression that returns a table of data. The COUNT function counts rows that contain the following kinds of values: When the function finds no rows to count, it returns a blank. Two arguments are needed for the COUNTX function. Click on data tab > and make relationship based on Product column in both tables. » 2 related articles » 1 related function. This function is deprecated. Other related functions are: CONCATENATEXUnderstanding the difference between LASTDATE and MAX in DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis Services, and Power Pivot in Excel data models. With this function, you can specify the start and end dates of your calendar, as well as the intervals (e. See Remarks and Related functions for alternatives. Similarly, if we are at one side (DimTable), there will be multiple records in the fact table table corresponding to one of the rows of DimTable, and we use the RELATEDTABLE () function to get the corresponding record in the fact table (a table). DAX functions are great and provide lot of flexibility to achieve desired output. . Related articles. Give measure a name as “Sales Value. ALLSELECTED_DAX = CALCULATE ( Sum (Orders [Sales]), ALLSELECTED (Orders [Product Sub-Category])) According to the ALLSELECTED definition, by default, it. The table on the many side of the relationship, tableMANY, is using direct query and the other, tableOne, is using import. If there is no relationship between the tables, you should have a common field at least, i. It will look up the related value in another table and return the result. The first example that you saw, used TREATAS to filter the SalesAmount in FactInternetSales by the value selected from DimCustomer. Drop me a comment if your errors in the RELATED function still persist, I’ll help you out 🙂 . RELATED is a DAX function used to retrieve a related value from another table. How to do a COUNTIF in Power BI; How to correctly use IF in DAX; Using Icons for KPIs in Power BI; How to copy and paste data from Power BI. It is a key function for performing advanced calculations and analysis in Power BI. Many of the functions in DAX are similar to the Excel date and time functions. You may need to create calculated columns in the Product table using the RELATED DAX function to achieve this process. A volatile function may return a different result every time you call it, even if you provide the same arguments. There is always a filter context for DAX expressions. A filter context is a set of filters over the rows of the data model. This function is deprecated. RELATED and RELATEDTABLE should be used here. • Because there is a relationship, the only input needed is the reference to the column in the dimension table that. Definition. Hey, there are two functions I would start with. Learn how to use the RELATED function to return a related value from another table in a calculated column expression or a table scanning function. Welcome back to the Power Pivot Principles blog. Dynamic pricing is a strategy that involves adjusting prices in real-time based on various factors such as demand, competition, and market conditions. DAX provides an extra edge by extracting key information from the data that is already present in your model. DAX Filter Functions. RELATED Vs LOOKUPVALUE DAX in Power BI. This function is deprecated. Many of the functions in DAX are similar to the Excel date. This function is deprecated. 2. USERELATIONSHIP uses existing relationships in the model, identifying relationships by their ending point columns. The RELATED DAX function can be utilized in advanced techniques for cash flow forecasting in Power BI. Is it possible to use the RELATED() DAX function with a Measure in Power BI? As per the official Microsoft documentation, the RELATED function needs a row context; therefore, it can only be used in calculated column expression, where the current row context is unambiguous, or as a nested function in an expression that uses a table. Related functions. One of the most powerful features of Power BI is DAX (Data Analysis Expressions), which is a formula expression designed for advanced data. Not recommended. Poznámky. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that. The RELATED function works by traversing the established relationships between tables and returning values from the related table. DAX Measures และ Calculated Columns. You can include columns in other related tables, if one or more many-to-one relationships exist to reach the referenced. The filtering functions let you manipulate data context to create dynamic calculations. CLOSINGBALANCEMONTH: Evaluates the expression at the last date of the month in the current context. Zadáte sloupec, který obsahuje požadovaná data, a funkce následuje existující relaci M:1, která načte hodnotu ze zadaného sloupce v související tabulce. The use of this parameter is not recommended. It returns a table that contains all the dates from the start of the current year to the latest available. TRUE/FALSE values are not supported. DAX Function แนะนำฟังก์ชัน Related. Try modifying your DAX as follows: Working Hours = IF (. The RELATED function is a very simple function to use in DAX. Hence, it can be used only in one of the following cases −. A. DAX ย่อมาจาก Data Analysis Expression โดย DAX คือชุดของ Functions, Operations และ Constants เพื่อการคำนวณใน Data Model ที่จะนำไปใช้กับ Power BI Desktop, Power Pivot, SQL Server. In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Power BI Model Relationships: Relevant DAX Functions. Close the bracket and press the “Enter” to get the new summarized table. » Read more. Each of these sections will be imported into Power BI as separate tables. The CALCULATE function in Power BI is a key tool for performing calculations and modifying filter contexts in the data model. » 6 related articles. The RLS rule filters the EmailAddress column of the hidden Salesperson table by using the USERNAME DAX function. Date and time functions help creating calculations based on dates and time. DAX Queries can be used to create dynamic reports in Power BI. The RELATED function works as VLOOKUP in Power BI VLOOKUP In Power BI VLOOKUP in Power BI helps the users fetch data from the other tables. Jump to the Alternatives section to see the function to use. In contrast to Microsoft Excel, which stores dates as a serial number, DAX date functions always return a datetime data type. See the syntax, parameters, return value, remarks, and an example of the RELATED function in a sales report. Hi, I have a question about the RELATED DAX function if someone can help please. Examples include sum, add, true, false, etc. To retrieve month names from a date column, the primary DAX function you would use is FORMAT, as previously mentioned. This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. A table or any expression returning a table must. The use of this parameter is not recommended. Column = LASTNONBLANK (SELECTCOLUMNS (RELATEDTABLE ('Interview Result'),"Status", [Final Status]),TRUE ()) Did I answer your question? Mark my post as a solution!The SUM function in DAX is an aggregation function that calculates the sum of a numeric expression for a specified column or table. End Date: The date you want to count the difference to. RELATED and RELATEDTABLE are two elementary but powerful functions. 2. The difference is the context of evaluation. While using this DAX function it is important to understand the following items: For this function to work it is important to ensure that there is a relationship created between the current table and the table with the related information you are. In this article, we will explore the benefits of using the RELATED function, provide a step-by-step guide to implementing it in Power BI, and showcase real-world examples of its effectiveness. In this video, we will learn about the DAX related function how to use it and when to use it. Syntax RELATED ( <ColumnName> ) Return values Scalar A single value of any type. This article describes how to create a virtual relationship in DAX using the TREATAS function, which is more efficient than approaches based on INTERSECT or FILTER. The FILTER function now returns a table where all rows have a value of. Learn more about ALLEXCEPT in the following articles: Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT. In our example, a calculated column that computes the year of the order would be as simple as this: 1. The use of this parameter is not recommended. See Remarks and Related functions for alternatives. The COUNT function counts rows that contain the following kinds of values: Numbers. e. It can only. The two solutions share a common goal: providing to the join function in DAX two tables that have one or more columns with the same data lineage. Description. Not recommended. Return value. (Optional) The qualified name of an existing column used to create summary groups based on the values found in it. Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. The name of an existing column in the table (or in a related table,) by which the data is to be grouped. Returns the specified date in datetime format. DAX provides you with the following unique features: Measures: Measures are the dynamic expressions for calculation stored in the DAX. Much like the CALCULATE function described earlier, the RELATED function is very important, and you will likely use it many times. Select the table that contains the records that need to be matched, go to the Home tab > Merge Queries > Merge Queries as New. Apply the DAX expression to a measure, calculated column, or calculated table in Power BI. A volatile function may return a different result every time you call it, even if you provide the same arguments. Power BI Filter DAX Function RELATED: Returns a related value from another table. DAX – GROUPBY Function. Apply the DAX expression to a measure, calculated column, or calculated table in Power BI. RELATEDTABLE: Returns the related tables filtered so that it only includes the related rows. The RELATED DAX function is used to return a related value from another table. A volatile function may return a different result every time you call it, even if you provide the same arguments. Power BI and other BI tools make excellent use of. Deprecated. » Read more. This function is a shortcut for CALCULATETABLE function with no additional filters, accepting only a table reference and not a table expression. Returns a related value from another table. The name given to a new column that is being added to the list of GroupBy columns,. In today’s example, we will be using Adventure Works Data. Because the active relationship is the one between Sales [OrderDate] and Date [Date], the result is the year of the order for each row. This parameter cannot be an expression. The RELATED DAX function is a powerful tool in Power BI that allows for efficient and accurate profitability analysis. Since there are many tables that have relationship to the. Learn how to use relationship functions in Data Analysis Expressions (DAX) to manage and Utilize relationships between tables. Give the “New column” name as “Discount %. This function is deprecated. In Level 17: Time Intelligence Functions: The DAX DATEADD() Function, you were introduced to the DAX Time Intelligence functions, beginning with the DATEADD() function. Open the LOOKUPVALUE function now. This. RELATED() Returns a value from a related table in the data model. The COUNT function internally executes COUNTX, without any performance difference. old_text is the existing text that you want to replace. I have two tables in my Power BI Report, Fact Table with directquery mode and dimension table with import mode. Why and when to use RELATED and its companion function RELATEDTABLE: two common DAX functions that are required when using a row. = SUMX(FILTER(InternetSales, InternetSales [SalesTerritoryID]=5), [Freight]) If you do not need to filter the column, use the SUM function. 'Main' [Location] == RELATED (Indianlocations [Location]), 9, IF ('Main' [Location] == RELATED (Otherlocations [Location]), 8, 0) ) In case you want to use IN operator, try following DAX. I can create a new column on table X with getting the column from table Y with RELATED function. While using this DAX function it is important to understand the following items: For this function to work it is important to ensure that there is a relationship created between the current table and the table with the related information you are. Following are the DAX Date and Time functions −. See Remarks and Related functions for alternatives. When using DAX, we can use the CROSSFILTER function to change how the cross-filter direction behaves between two columns defined by a relationship. RELATED Function in DAX does not shows me related tables. Returns a table with a set of selected columns. DAX RELATEDTABLE function is equivalent to DAX CALCULATETABLE function with no logical expression. But it doesn't let me do the opposite ( creating a new column on table Y with getting the column table X). You can use the DAX DATEDIFF function third argument to select the difference value. Deprecated. This article showcases the use of CONCATENATEX, a handy DAX function to return a list of values in a measure. The DAX DATEDIFF function accepts YEAR, MONTH, DAY, SECOND, MINUTE, HOUR, QUARTER, WEEK. Sorted by: 1. The RELATED DAX function is an essential feature in Power BI that allows users to establish relationships between tables. Learn how to use RELATED and RELATEDTABLE, two common DAX functions that are required when using a row context with relationships. The filter and value functions in DAX are some of the most complex and powerful, and differ greatly from Excel functions. ”. This function can traverse multiple relationships. Returns the smallest numeric value in a column, or between two scalar expressions. Other related functions are: MAXX; MAXADAX Patterns: Related distinct count. When the function finds no rows that are non-blank, it returns a blank. Calculated tables are best. The context of the cell depends on user selections in the. You can use something like this. This article shows how to use DAX and conditional formatting together to highlight the minimum and maximum values in a matrix in Power BI. So you can try to update your formula like this. Due to this. Go to the Modeling tab> Click on New table. table. For example, the following measure calculates the quantity by dividing the existing Sales Amount measure by the Unit Price value of the selected product. Jump to the Alternatives section to see the function to use. Just set the appropriate relationship between Table A and Table B and create a new column with the. Adds calculated columns to the given table or table expression. RELATED DAX Function (Relationships management) Syntax | Return values | Remarks | Examples | Articles | Related Returns a related value from another table. The name given to a total or summarize column, enclosed in double quotes. The RELATED function works by traversing the established relationships between tables and returning values from the related table. 5. RELATED and LOOKUPVALUE are DAX functions that used in a calculated column when you need to reference columns from another table to the current table. B. Related articles. Column = RELATED (FactTable [Key]) RELATED. The next argument is “Search Column Name 1,” so this will. Both RELATED and LOOKUPVALUE are DAX functions that are used in a calculated column when you need to reference a column from another table to return a value that is related and has an exact match to the current row. Returns the largest value in a column. Table: The table from. Remarks Learn how to use the RELATED function in DAX to access a field's value from another table that is related to the existing table in Power BI. g. Power BI is one of the most robust and powerful business intelligence tools out there. The RELATED DAX function in Power BI presents an incredible opportunity for organizations to unlock the true potential of their balance sheet analysis. I have looked at many posts related to this issue but have not been able to find a solution. SubRegion = RELATED ( 'Account'[SubRegion] ) RegardsBusiness Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER. The COALESCE function in DAX. The DATESYTD() function in DAX enables us to calculate values for the year-to-date period. Download Sample Power BI File. This function can only be used within a window function expression. Jump to the Alternatives section to see the function to use. Return Value and Further Remarks. Volatile. Power BI is one of the most robust and powerful business intelligence tools out there. DAX ย่อมาจาก Data Analysis Expression โดย DAX คือชุดของ Functions, Operations และ Constants เพื่อการคำนวณใน Data Model ที่จะนำไปใช้กับ Power BI Desktop, Power Pivot, SQL Server. DAX coding style using variablesSyntax: The syntax for both filter functions is similar, except for the function name: ALL: ALL (TableName or ColumnName,. The Related Function is a DAX function in Power BI that allows you to retrieve related values from a related table in the Data Model. The functions include. Using the common field you can join both tables using FILTER function. Related articles. Hi @edithees , It seems you are adding a custom column in Power Query Editor, but the RELATED function is used for DAX. RELATED is a DAX function used to retrieve a related value from another table. This function is not supported for. 5 Important DAX Functions in Power BI for Beginners 1. Power BI Model relationships in Power BI Desktop Article 10/27/2023 11 contributors Feedback In this article Relationship purpose Relationship properties. It is a scalar function, meaning it returns only one single value, and it gets one single input parameter. Create the necessary relationships between the tables by specifying the related columns and their relationship type (e. But it doesn't let me do the opposite ( creating a new column on table Y with getting the column table X). Step 3: Once the relationship is established, you can use the RELATED function in your DAX formulas. BLANK ( ) RELATED. A measure is used in the Values area of a PivotTable. Not recommended. ALLSELECTED DAX function Sample Data. Therefore, while the RELATED output is one unique value, the output of the RELATEDTABLE function is a. Volatile. Leverage other DAX functions, such as SUM and AVERAGE, to perform calculations and generate forecasts based on the historical sales data and the related data fetched using the RELATED function. This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When the function finds no rows that are non-blank, it returns a blank. See Remarks and Related functions for alternatives. Related functions. The RELATED function retrieves values from a related table based on the active filter context.