I want to sum the NumEmp column if Group1 equals "Corp Employees" but only for unique AcctNum.. The logic I would follow is that you need to filter the table twice, for Names with Year=2014 & for Names with Year=2015. The only argument allowed to this function is a column. For example, let’s use a table visualization of sales orders filtered down to the most recent quarter via a slicer. While it’s not advisable to use a data model with blanks, there are situations where it happens. Funktionen zur Tabellenmanipulation. To get the desired results, you will have to use DAX to propagate filters from the Product and Calendar Table to the Customer table. 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. This can come in handy especially when you want to compare values of other items with specific items. a. Values Using DAX Inside Power The filtering functions let you manipulate data context to create dynamic calculations. DAX DISTINCT Function is categorized under Filter functions. – Carlos Porta. In this category. Power BI DAX – CALCULATE AND FILTER and Implicit and Explicit … When the function finds no rows to count, it returns a BLANK, otherwise it returns the count of distinct values. Viewed 2k times 0 1. How to get the Distinct Count and Sum with Measure as a Filter in … Remarks. CALCULATETABLE (VALUES (Tasks [Week]), FILTER (Tasks, Tasks [Fix Version] = SELECTEDVALUE (Tasks [Fix Version]))) I have a table Tasks, and want to firstly apply the filter "Tasks [Fix Version] = SELECTEDVALUE (Tasks [Fix Version])" then get the unique value of the column Week by using VALUES. it seems that my solution did not work. Our sales table contains multiple rows with the same order number. On a multi-billion-row table that is likely to be partitioned, the column needs to be recomputed for the … This short post describes the differences between DISTINCT and VALUES. Here is a measure formula that I attempted: DistCountActiveMonths = CALCULATE(DISTINCTCOUNT('Net Revenue Data'[Publisher Name]),FILTER('Net Revenue Data','Net Revenue Data'[Active Month]=1)) Blank row in DAX. To skip the BLANK value, use the DISTINCTCOUNTNOBLANK function.