topic Re: ALL doesn't work as expected in DAX Commands and Tips

ALL doesn't work as expected

a_gaisin — Tue, 26 May 2020 20:54:23 GMT

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 values. The code of the measure is the following:

Count = COUNTROWS(ALL('Table'))

Here's the result that I have:

It's quite unexpected, because I thought that I will get 7's everywhere, because ALL will remove all the filters. But as you can see there are several blank cells.

How do I make all cells equal to 7?

Thank you.

Re: ALL doesn't work as expected

Anonymous — Tue, 26 May 2020 21:05:05 GMT

Hi a_gaisin ,

Not sure what you want to acheive.

Values are blank as there is no entry for IYEJ...... against nature =1 and so on.

Incase you want all 7, you will need to add the entries in the source file.

By the way, wht is the end goal.

Regards,

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Re: ALL doesn't work as expected

Anonymous — Tue, 26 May 2020 21:30:05 GMT

You will know why you don't get 7 everywhere if you open DAX Studio and intercept the query that your visual generates and sends to the calculation engine.

You'll understand this result immediately.

Best
D

Re: ALL doesn't work as expected

a_gaisin — Tue, 26 May 2020 22:20:21 GMT

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.

Re: ALL doesn't work as expected

Anonymous — Tue, 26 May 2020 22:31:27 GMT

[Row Count] = COUNTROWS( 'Table' ) + 0

Best

Re: ALL doesn't work as expected

a_gaisin — Tue, 26 May 2020 22:59:39 GMT

Anonymous thank you for response, I tried it already, and it doesn't work.

Re: ALL doesn't work as expected

Anonymous — Wed, 27 May 2020 00:25:40 GMT

Looking at the DAX query that the matrix visual produces... It's not possible to do what you want to do.

Best
D