Debug card visual showing count

[kman42]

I have a table visual that correctly shows some filtered records. I also have a card visual that just shows the count of this table. I created the card visual by just duplicating the table visual and changing the visual type. The problem is that the card visual shows the wrong count. All of the filters are the same on the two visuals. I can't figure out how to debug the card visual because I don't know how to see the data underlying the card visual. The card visual consistently shows a higher count than the table. I have it set to count distinct, although there are no duplicates.

Thanks!

[V-lianl-msft]

Hi @kman42 ,

It may be that the context affects the filter conditions.

Cloud you share the sample data and the DAX formula?(It is better to share sample .pbix after masking any sensitive data)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mihart]

Hi @kman42 

Here's a way you can figure out what's going on.

In the report, select the Card, and choose "export data"

IF you have both options, do it twice -- export first time using "summarized data" and export second time using "underlying data".

See if comparing the data gives you your answer.

[kman42]

I only have one option and it exports just the summarized count. Why is that?

[mihart]

Hi @kman42 

You may not have permissions to the underlying data.  Or, it may be turned off for your tenant.  

If you have permissions, open your workspace and select Settings.

And change the selection for exporting:

[az38]

hi @kman42 

I can suggest that in table visual you had a row-context that affect to calcultion

if you can it would be great to provide data example to help you