Forum Discussion

a_gaisin's avatar
a_gaisin
Frequent Visitor
6 years ago
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...
  • Anonymous's avatar
    Anonymous
    6 years ago
    Looking at the DAX query that the matrix visual produces... It's not possible to do what you want to do.

    Best
    D
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)

a_gaisin's avatar
a_gaisin
Frequent Visitor
6 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    [Row Count] = COUNTROWS( 'Table' ) + 0

     

    Best

    D

    • a_gaisin's avatar
      a_gaisin
      Frequent Visitor
      6 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        Looking at the DAX query that the matrix visual produces... It's not possible to do what you want to do.

        Best
        D