Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue with COUNTROWS DAX

Hi,   Am facing an issue with the DAX function CountRows as it is giving incorrect value. The table has only 2 rows but CountRows DAX gives 4 rows.    
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    So is your issue solved now?If so,could you pls mark the reply as answered to close it?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Can you share the formula that you use to count the rows

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    The formula is COUNTROWS(JAMVATOPTEMP) where JAMVATOPTEMP is the table name.

    This is very straightforward as am not doing any transformation on the table. I just load the table and add all the columns to the table visual. When i export the data from the table visual to excel i get only 2 rows,but the DAX gives me 4 rows