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

[Cathryn]

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?

[v-xjiin-msft]

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.

[Ashish_Mathur]

Hi,

Try one of the following measures:

=DISTINCTCOUNT('Table A'[Id])

=COUNTROWS('Table A'[Id])

Does any of these work?