Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper III
Helper III

Debug card visual showing count

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.



Community Support
Community Support

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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


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.




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

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:



Community Champion
Community Champion

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

do not hesitate to give a kudo to useful posts and mark solutions as solution

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.