Combine Values Using DAX Inside A Measure. I also want to show how you can create a dynamic text by utilizing the COMBINEVALUES function. If you set the filter within your DAX its an explicit filter and it will override what is in your visual . I’m new to PBI/DAX. There is another version of the DISTINCT function, DISTINCT (column), that takes a column name as input parameter. This pattern is included in the book DAX Patterns , Second Edition. SUMX requires a table or an expression that results in a table. You need to nest the DISTINCT function within a formula, to get a list of distinct values that can be passed to another function. So the unique values that are returned and counted are only from a filtered sub-set of values. The results of DISTINCT are affected by the current filter context. dax distinct values with filter - champcaine.com DISTINCT Instead of just counting the number of distinct count values in the entire table using only the DISTINCTCOUNT function, the pattern filters only those values related to events filtered in another table. Similarly, we will use the Countrows() and distinct count with filter.. The DISTINCT (Column) Function falls under the category of the Filter Functions in DAX. 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. Then, using the table returned by the filter, focus on the Cost price column. » Read more. b. DAX provides two functions for returning distinct values: DISTINCT Function and VALUES Function. … #4. dax distinct values with filter. Check out what I’ve done here. Here, instead of using all the data in a table, you use the FILTER function to specify which of the rows from the table are used.. When you use the DAX VALUES function in a context that has been filtered, such as in a PivotTable, the unique values returned by VALUES are affected by the filter. Modified 1 year, 1 month ago. Function Description; ALL: Returns all the rows in a … table of multiple values was supplied Blank row in DAX. We will discuss five variations, and then have a look at their performance. 12. In most scenarios, when the argument is a column name, the results of the VALUES function are identical to those of the DISTINCT function. filter ( table , containsstring ( 'table'[Name] , 'distinct table'[name] ) , "stuff" , 'table'[name] ) RETURN. DAX provides two functions for returning distinct values: DISTINCT Function and VALUES Function. – Carlos Porta. -- the blank row if you just use the table name. DAX-Referenz (Data Analysis Expressions) DAX-Funktionen. Analyzing the performance of DISTINCTCOUNT in DAX - SQLBI