Forum Discussion

Cathryn's avatar
Cathryn
Icon for Helper III rankHelper III
8 years ago

Adding rowcount from 2 different tables doesn't match when add manually

Hi All -

 

 

I have a card on my dashboard where I drop the ID field from Table A and it counts the rows.

 

 

If I create a measure to count Table A, I don't get the same number

 

Total Rows Table A = COUNT('Table A'[Id])

 

Why is this and how do I make sure these 2 numbers match so I know it's doing the same calculation?

 

 

Need Help

2 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    Try one of the following measures:

     

    =DISTINCTCOUNT('Table A'[Id])

     

    =COUNTROWS('Table A'[Id])

     

    Does any of these work?

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi Cathryn,

     

    Maybe you are choosing COUNT(DISTINCT) for the Card. However your measure is just a COUNT(). 

     

    By the way, where did you put this measure? Could you please share us some screenshots about your dashboard? 

     

    Thanks,
    Xi Jin.