multi-table totals

[IsraelHerrera40]

Hola buen dia.

Necesito obtener la suma del total de 3 tablas, estas mismas contienen datos tipo texto y numerico, no es de interes si es numerico ya que cada celda es un analisis y quisiera sumar eso el numero de analisis no el resultado.

Estas son mis 3 tablas. Lo que es el nombre de la columna EB, BMA,Hongos, Levadura, Salmonella y Cronobacter

son analisis y ya que cada columna contiene ya sea un numero o texto independientemente de que el numero sea 0 quisiera que contabilizara esa celda como 1 para tener un total de analisis

Quisiera tener un total de analisis, Ejemplo:

EB: 250

BMA: 600

Hongos:800

Levaduras:350

Salmonella: 150

Cronobacter: 188

[v-rongtiep-msft]

Hi @IsraelHerrera40 ,

How to get the result EB: 250?

 please provide more details with your desired output and pbix file without privacy information (or some sample data) .

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Rongtie

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

[IsraelHerrera40]

For example,in data view i have a the table contains: date, sample, EB, Salmonella, cronobacter and BMA,index. Each cell in the columns is an analysis that was carried out regardless of whether the result is 0, I would like it to be counted by cell that contains any character, it does not matter if it is numeric or text.

I would like to have my table in the report view something like the image below.