Solved: count the occurrences of measure - Power BI Similarly, we will use the Countrows() and distinct count with filter.. We will look at DAX COUNT and COUNTX – Impact of Using Measures and Columns. Update: 16 December 2016 (I got a comment from Marco Russo, who suggested that can use the FILTERS DAX Syntax which will “Return a table of the filter values applied … power bi The date column must not have any missing dates. FILTER: Returns a table that represents a subset of another table or expression. Filters selected have no data to return ) separated by commas, of a column Measure. When all three columns are set to Decimal Number, Power BI returns 3.26. The IF … Shares: 296. The Power Bi COUNT function counts the number of cells in a column that nonblank values. DAX COUNT and COUNTX - Impact of Using Measures and Columns count