Forum Discussion

IsraelHerrera40's avatar
IsraelHerrera40
Regular Visitor
3 years ago

multi-table totals

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

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      IsraelHerrera40
      Regular Visitor
      3 years ago

       

      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.