Showing the Total of an Excel column in Power BI

[jonclay]

Hi everyone

I have a Power BI report that mixes data from a SQL database with data from an Excel spreadsheet. I can get the totals to appear for the data from the SQL database, but I'm having problems showing the totals for the Excel data.

My report currently looks like this:

The Excel spreadsheet looks like this, and it's the 6947 total for the column that I want to show in Power BI along with the rest of the totals:

For some reason, the Power BI report is not picking up the total from the Excel spreadsheet.

Does anyone know why this might be?

Many thanks
Jon

[jonclay]

Hi @Daryl-Lynch-Bzy 

Of course, that's the answer!! Many many thanks for your help.

[Daryl-Lynch-Bzy · Accepted solution]

Hi @jonclay - I look like the Column contain the 90 is list of String/text values instead of a Measure.  You will only see Subtotals on the columns based on Measures.  So the first six columns in the Tables are not measures.