Forum Discussion
Solved
ALL doesn't work as expected
Hello, I'm trying to understand how dax ALL function works. I have a toy dataset , and a matrix visual in Power BI with "projet id" on rows, and "nature" on columns, and measure "Count" on val...
Looking at the DAX query that the matrix visual produces... It's not possible to do what you want to do.
Best
D
Anonymous Anonymous the initial example was quite artificial. Let me explain what I'm really trying to do. For each (project,nature) pair I want my measure to output the number of times it presents in the Table. For example, there's only one line corresponding to pair (0GWS..., 1) in the Table, and there's no lines corresponding to (1YEJ...,1). So, in the first case measure should output 1, and in the other - 0. Is there a way to do that? Thank you.
[Row Count] = COUNTROWS( 'Table' ) + 0
Best
D
Anonymous thank you for response, I tried it already, and it doesn't work.
- Looking at the DAX query that the matrix visual produces... It's not possible to do what you want to do.
Best
D