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!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

The issue was that there were duplication in the data and these duplicated records are not shown in the table visual be default. Adding an index column to the table resolved my issue to showl all the duplicated records in the table visual.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    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!