Card not pulling data from SharePoint Excel tab

Hi KPro17 

From your screenshot, you are using Count to aggregate Business column. I recommend that you use Sum instead. You can right click on Business column in the Fields or Values box and select Sum. Just as below. 

In addition, the Card visual is only able to display an aggregated value, so it will display the total of the whole Business column. If you want to show the value for every user, you can use Table visual. Put both user name and Business columns into a table visual, then you will see the total for every user. Or if you want to show the total in a Card visual for a user at a time, you can add a slicer to the report page and put User name column into it. Then use the slicer to filter users. 

Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Docs

Slicers in Power BI - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.